Lynda – Visual Studio Essential Training: 11 Data Tools (updated Aug 30, 2017)-0daytown

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