Chapter 2. Creating SQL Server Database Objects From Visual Studio .NET

You will learn about the following in this chapter:

• Create a new SQL Server database from within Visual Studio .NET

• Define tables and fields

• Define a primary key and other indexes

• Define relations between tables

• Define defaults and constraints

• Create views

• Create stored procedures

When starting out with working with databases, it's a good thing to know how to create them. This example shows how to create a SQL Server database using Visual Studio .NET and also talks about servers and security.