In most SQL Server data project, there are a bunch of SQL file. You won’t find any C# or VB code in the project. Yet, there is a build menu available for the project. This tutorial explore what it means to build a data project in Visual Studio. You’ll see how it catches T-SQL syntax errors and adds them to the Error List. Plus, you’ll learn about the dacpac files generated during the build process and how they enable a simplified deployment process to a deployment database.
- [Voiceover] Let's talk about the Build menu…and what it means for a data project.…In a normal project, one where you'll write…C#, Visual Basic, C++, or F#,…building the application does a number of things.…The primary action during a build is to run the compiler…and generate a binary representation…of the application code.…In a data project, there is no code, per se,…unless you have some manage stored procedures…in the project.…Usually, it's a bunch of SQL that represent…the database object,…but there is still a build action…available on this menu.…What does it do?…One action taken during a build…is that Visual Studio verifies that…the T-SQL syntax is correct…and shows an error list when there are errors.…
Let's start by doing a build and see what happens…when there are no errors.…In Visual Studio, in the output window,…I'll see a list of actions that were taken during the build,…and at the bottom I see one build succeeded.…Now I'll go break some of my stored procedures,…so I'll go to my Solution Explorer,…open up my Stored Procedures folder,…
- 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.