Chapter 28Visual Database Tools

Wrox.com Code Downloads for this Chapter

The wrox.com code downloads for this chapter are found at www.wrox.com/go/professionalvisualstudio2015 on the Download Code tab. The code and any related support files are located in their own folder for this chapter.

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

Visual Studio 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 2015, which can be collectively referred to as the Visual Database Tools.

Database Windows in Visual Studio 2015

A number ...

Get Professional Visual Studio 2015 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.