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
Видео SQL Data Tools In C# - Database Creation, Management, and Deployment in Visual Studio канала IAmTimCorey
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
Видео SQL Data Tools In C# - Database Creation, Management, and Deployment in Visual Studio канала IAmTimCorey
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Entity Framework Best Practices - Should EFCore Be Your Data Access of Choice?How to connect C# to SQL (the easy way)How Important is Attention to Detail as a Developer?Setting Up a GitHub Repository - A TimCo Retail Manager VideoTop 10 C# Best Practices (plus bonuses)Working With The File System in C# - Managing Folders and FilesCreating a C# Application: From idea to finished productSQL Server Data Tools for Visual StudioSQL Development Made Easy with Docker - Install SQL in 5 minutes or less!SQL Stored Procedures - What They Are, Best Practices, Security, and More...C# Advanced Async - Getting progress reports, cancelling tasks, and moreC# Desktop App Deployment with Squirrel - Easier than MSI Files, Better than ClickOnceAdvanced Dapper in C# - SQL Transactions, Mulitple DataSets, UDTs, and moreFluent Validation in C# - The Powerful Yet Easy Data Validation ToolWPF Login Form Creation - A TimCo Retail Manager VideoWie eine SQL-Server-Datenbank deployen? | Thorsten KansyC# Async / Await - Make your app more responsive and faster with asynchronous programmingDatabases with SSDT: Deployment in CI/CD process with Azure DevOpsIntroduction to ASP.NET Core MVC in C# plus LOTS of Tips