SQL Data Tools In C# – Database Creation, Management, and Deployment in Visual Studio


Full courses: https://www.iamtimcorey.com/courses
Source Code: https://leadmagnets.app/?Resource=SQLDataTools
Patreon: https://patreon.com/IAmTimCorey
Newsletter signup: https://signup.iamtimcorey.com/

What if I told you that you could create a SQL Database in Visual Studio, manage it like any other project, track it with source control, deploy it to multiple environment, and refactor it like C# code? In this video, I am going to show you how to do all of those tasks and more. The best part is that it is free and comes baked into Visual Studio. And no, we aren’t going to be using Entity Framework, although this method is compatible with Entity Framework.

Chapters provided by: Ralfs HBK
0:00 – Intro
1:12 – SQL Server Database Project in Visual Studio
4:35 – Designing a new SQL database: adding and editing tables
11:22 – Adding a foreign key
12:46 – Publishing the database
17:10 – Putting data in database
18:52 – Adding a View
23:20 – Adding a Stored Procedure
25:00 – Publishing database with the added changes
27:06 – Changing column names
31:41 – Schema Compare tool
39:37 – Database Queries
41:26 – New Database data: Data Comparison tool
43:13 – New Database data: Scripts
47:41 – Importing existing database to SQL project
49:49 – Summary and concluding remarks