Chapter 27Visual Database Tools
- Understanding the data-oriented tool windows within Visual Studio 2013
- Creating and designing databases
- Navigating your data sources
- Entering and previewing data using Visual Studio 2013
Database connectivity is essential in almost every application you create, regardless of whether it’s a Windows-based program or a website 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 filesystems and local servers, with a Server Explorer, data controls, and data-bound components. The underlying .NET Framework included ADO.NET, a retooled database engine more suited to the way applications are built today.
The Visual Studio 2010 IDE includes tools and functionality to give you more direct access to the data in your application. One way it does this is by providing tools to assist with designing tables and managing your SQL Server objects. This chapter looks at how you can create, manage, and consume data using the various tool windows provided in Visual Studio 2013, which can be collectively referred to as the Visual Database Tools.
DATABASE WINDOWS IN VISUAL STUDIO 2013
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 ...
Get Professional Visual Studio 2013 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.
