O'Reilly logo

Professional Visual Studio® 2010 by Chris Anderson, Michael Minutillo, David Gardner, Nick Randolph

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 26. Visual Database Tools

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.

DATABASE WINDOWS IN VISUAL STUDIO 2010

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required