Microsoft Visual Studio Design-Time Features

Visual Studio offers some design-time features that are handy when you’re working with SqlCommands. As shown in Figure 4-2, the Server Explorer window gives you the ability to create and execute queries against your database easily at design-time.

The Server Explorer window

Figure 4-2. The Server Explorer window

You can also use Server Explorer to examine your database’s schema. When you’re writing your ADO.NET code, you can use Server Explorer to check the names of tables, columns, and stored procedures easily by drilling down into your connection. You can also examine data types of columns in your tables and views, and parameters ...

Get Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.