A key benefit of the SQL Server Express Local is the ability to auto connect to the database. It does this on-demand feature by monitoring the databases used in applications, when an open connection is requested, the LocalDB video application request and in a Visual Studio request.
- [Voiceover] I'm working with the developer…command prompt again.…This time I'll explore details…about each localdb named instance.…If I run this command "sqllocaldb i".…It'll list all of the named instances…that I have used on this computer…with this user account.…I'd like to learn some details…about the v11.0…named instance.…So, I'll use that same command,…only this time I'll use the name of the instance…v11.0…with the i switch.…And I get a listing of the version number,…the name, whether it's a shared instance.…
Which it's not in this case.…The owner account, and there's also an auto-create,…and the state equals stopped.…So, what does this mean?…Auto-create means,…that if I attempt to create to a database…using this path, to this named instance,…it's supposed to automatically add the database…to the running instance of SQL server.…The state currently stopped,…that means it's not running.…And, I can see that, as of the day that I'm recording…that it says about 13 months ago was the last time…that this program ran.…
- 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.