This tutorial shows how to work with Server Explorer to work with connections after reopening Visual Studio. It shows how to disconnect and reconnect as needed during a coding section. And you’ll see how to delete a connection in Server Explorer.
- [Voiceover] Let's play through this scenario.…I'm a developer who's been working with…these three connections in Server Explorer.…I went home for the weekend and on Monday morning…I come to work and I open up Visual Studio…and this is what I see when I look in Server Explorer.…It shows that I have three data connections.…What this proves is that Visaul Studio…persists the connection information in Server Explorer,…but you also notice that it didn't automatically connect me.…I have a red X on the icon, not the green connected icon.…So if I want to connect, it's quite simple.…I just have to click on this expand node.…
That causes a query to go out to the server…and now I got the connected icon…and now I can drill down and see information…like in this Tables folder.…We'll do the same thing with this SQL Server…database down here.…Expand the node and you see it automatically connects.…Now if I were to close down Visual Studio and reopen,…just to reiterate what I said a few minutes ago,…is it would automatically close these connections.…
- 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
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.
1. Database and Data Integration
The Azure data sources2m 35s
2. SQL Server Express LocalDB
3. Server Explorer
4. SQL Server Object Explorer
5. Queries, Views, and Stored Procedures
6. Compare databases
7. SQL Server Data Project
8. Azure Data
Get an Azure account1m 10s
9. Entity Framework
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.