Configuring Database Options in Visual Studio 2010

VS has many database configuration settings that you can view via the Tools | Options

menu and selecting Database Tools, as shown in Figure 2. For example, one of the

Figure -2 Database Tools options

options found after clicking the arrow button to expand Database Tools and then selecting

Table And Database Designers is "Prevent saving changes that require table re-creation."

VS will not allow you to save a foreign key change to existing tables. However, by

unchecking "Prevent saving changes that require table re-creation," you'll be able to save

foreign key changes to an existing table.

As with so many other features of VS, there are literally dozens of database settings; most

are intuitive if you already understand SQL Server. Other options differ, depending on the

version of VS you have, and your Options screen might not look the same as Figure 2.

Now that you know how to create databases, tables, and stored procedures, you'll need

to know how to use your database from code.