WHAT'S IN THIS CHAPTER?
Understanding the data-oriented tool windows within Visual Studio 2010
Creating and designing databases
Navigating your data sources
Entering and previewing data using Visual Studio 2010
Database connectivity is essential in almost every application you create, regardless of whether it's a Windows-based program or a web site or service. When Visual Studio .NET was first introduced, it provided developers with a great set of options to navigate to the database files on their file systems and local servers, with a Server Explorer, data controls, and data-bound components. The underlying .NET Framework included ADO.NET, a retooled database engine that is more suited to the way applications are built today.
Visual Studio 2010 took those features and smoothed out the kinks, adding tools and functionality to the IDE to give you more direct access to the data in your application. This chapter looks at how you can create, manage, and consume data using the various tool windows provided in Visual Studio 2010. These can be collectively referred to as the Visual Database Tools.
A number of windows specifically deal with databases and their components. From the Data Sources window that shows project-related data files and the Data Connections node in the Server Explorer, to the Database Diagram Editor and the visual designer for database schemas, you'll find most of what you need directly within the IDE. ...