When a file based connection is added to Server Explorer with the SQL Server Database file data source option, the default name of the database in SQL Server Object Explorer is the fully qualified path to the database file. This can make it hard to read the name of the database. This tutorial shows how to use a “logical name” to create a connection with a more readable name.
- [Voiceover] Earlier in this chapter…I made a copy of the Tours.mdf file and added…it to this database edit folder.…It's in SQL Server Object Explorer,…it works fine.…I have one more issue with the way…that this is showing in here.…It's the readability of this file name.…Visual Studio uses an all cap path…and that's not very readable.…So let's fix that.…Switch to Server Explorer and I'll…choose to delete this connection.…Yes, I know I just added it but bear with me,…It'll be worth it.…Then I'll switch over here and choose…to detach the database.…
And back to Server Explorer and choose…to connect the database.…When I created that new data connection…a few minutes ago in the other video…I used this item, the SQL Server Database file.…And that works very simply but that's…where I get that unreadable path name.…What I'll do this time is use Microsoft…SQL Server as the data source then enter…the server name.…I'll use the local db instance inside parenthesis,…then a slash, then the word MS SQL Local DB.…On the bottom of the screen I'll choose…
- 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.