Create an MSSQL Server Database using Entity Framework Core 9 and .NET 9 - 2/4
In this video, we’ll implement the database design from our previous tutorial using Entity Framework Core (EF Core)in a .NET Console App with Visual Studio Code. This is a key part of our complete Database Design and Implementation Series.
You’ll learn:
✅ What is ORM and how Entity Framework Core simplifies database operations
✅ How to create a .NET Console App using Visual Studio Code
✅ How to install essential NuGet packages for EF Core
✅ How to define data models and map them to SQL Server tables
✅ How to use EnsureCreated() vs. the EF Core Migration method
This tutorial is perfect for beginners learning C#, .NET, and database development with EF Core. Follow along step by step to build a real-world database application from scratch.
Commands Used:
🔹dotnet ef database update --project project_name
🔹dotnet ef migrations add migration_name --project project_name
🔹dotnet tool install --global dotnet-ef
Chapters:
00:00 Introduction
00:10 What is Object-Relational Mapping?
01:11 Create a Console Application
01:23 Add EntityFramework Core NuGet Packages
03:00 Create the AppDbContext Class
04:23 Create the User Data Model
05:30 Add the User Data Model to AppDbContext
05:53 Run an MSSQL Database on Docker
06:29 Create a Database Using the EnsureDatabase Method
08:43 Create a Migration
09:59 Create a Database Using the Migration
Related Videos:
📌 • C# with Visual Studio Code on Mac | Set Up...
📌 • Install Docker on Mac & RDBMS on Docker | ...
📌 • How to Install Azure Data Studio on Mac an...
📌 • How to Design a Database | Relational Mode...
📌 • C# with Visual Studio Code on Mac | Set Up...
📌 • How to Install Visual Studio Code on Mac |...
More from us:
📌Essential Mac Software Installation Guides: • Essential Mac Software Installation Guides
📌 MacOS Tips and Tricks: • MacOS Tips & Tricks | Apple Ecosystem
📌 C#: • C#
📌 Apple Ecosystem: • Playlist
📌 Database: • C# | Database Design & Entity Framework Co...
👍 Like this video if it helped you
💬 Comment below if you have any questions
🔔 Subscribe and turn on notifications so you don’t miss upcoming videos in this series!
#EntityFrameworkCore #DotNet #SQLServer #VisualStudioCode #EFCore #DatabaseDesign #ORM #AzureDataStudio #CSharp