Duration: 16 minutes
Summary: In this video, we will continue to create the database by scripting what we already have. We will create scripts for every table and the database. It is important to have those scripts handy incase we need to re-create the database. In a development shop, you normally keep these scripts in a version control system (like TFS) so you can check them out and edit them when necessary. Then we will create a script that inserts the records into the ItemType table. This will serve as a standard that you can apply to other tables. It is important to save these scripts in TFS so you can keep track of their updates and run them when you need them.
Methodology of the development of example: Good coding standard and simplified design to illustrate the key points.
Technology Used: Windows Application and Visual Studio 2010
Keyword: Windows Application, Visual Studio 2010, Database, Table, Row, Column, Script, Insert varchar, int, bit, Team Foundation Server.