Server Explorer and SQL Server Object Explorer are similar in many ways. This video demonstrates how they use the same windows for working with data entities, and explains why the rest of the demonstrations in the course use SQL Server Object Explorer.

- [Voiceover] In Server Explorer I can work…with the information from tables.…You've seen this in the other video…if you watched it.…Like I can go to this table here, Testimonials,…right-click on it and choose Show Table Data.…It also turns out that I can do the same…task using SQL Server Object Explorer.…When I open SQL Server Object Explorer…I see different databases including…the one that I currently have open in Server Explorer.…It's this one here.…I can go to this item and choose DBO.Testimonials…and right-click on this and choose View Data.…

Keep your eye up here in this tab.…You see what happened?…It switched me over to that tab.…So what's happening here is both Server Explorer…and SQL Server Object Explorer use…the same editor window to show me the data,…let me modify the data, and let me add new rows.…It's the same one I work with changing…the table structure.…If I right-click on this table over here…and choose Open Table Definition…I see a scream where I can read information…about the keys and constraints that are…

Resume Transcript Auto-Scroll

Author

Updated

8/30/2017

Released

8/26/2016

Database connections separate rich, enterprise-level applications from the rest. If you're developing with Visual Studio, you have a variety of tools available for managing database connections, manipulating tables, querying data, and deploying projects. Plus, you have your choice of platform. Visual Studio 2015 supports SQL Express LocalDB and the full edition of SQL Server, as well as Azure cloud-based data services. Join Walt Ritscher as he walks through your integration options and tools for working with data in this powerful IDE. Learn how to manage connections with Server Explorer, manage individual database elements with the SQL Server Object Explorer, and create custom queries, views, and stored procedures within the Visual Studio environment. Plus, find out how to deploy projects to Azure and integrate Visual Studio with Entity Framework, an object relational mapper that "enables .NET developers to work with relational data using domain-specific objects."

Topics include:

Exploring integration with Azure data sources and other Microsoft databases

Working with SQL Server Express LocalDB

Connecting to databases with Server Explorer

Working with database tables

Manipulating tables with the SQL Server Object Explorer

Creating queries and custom views

Creating stored procedures

Comparing databases

Building a data project in Visual Studio

Refactoring a database object

Deploying the database

Connecting to Azure databases

Deploying data projects to Azure

Integrating Visual Studio with Entity Framework

Skill Level Beginner

3h 15m

Duration

118,264

Views

Show MoreShow Less

Q: This course was updated on 08/23/2017. What changed?

A: The following topics were updated: installing the SSDT features and why LocalDB is essential for developers.