SQLite + EF Core + ASPNET Core Web API + CRUD + Views + Loading Related Data
Hey Programmers,
In this video, I am showing how you can perform database operations for SQLite database using EF Core.
GitHub Link – https://github.com/CuriousDrive/EFCore.AllDatabasesConsidered
Topics:
1. CRUD Operations
2. Loading Data from Views
3. Loading Related Data
Commands:
Add Connection String :
Data source=../Database/northwind.sqlite
Packages to install :
dotnet add package Microsoft.EntityFrameworkCore.Design
dotnet add package Microsoft.EntityFrameworkCore.Sqlite
dotnet add package Microsoft.AspNetCore.Mvc.NewtonsoftJson
Install & Update dotnet ef tool :
dotnet tool install –global dotnet-ef
dotnet tool update –global dotnet-ef
Scaffold SQLite Database :
dotnet ef dbcontext scaffold Name=NorthwindDB Microsoft.EntityFrameworkCore.Sqlite –output-dir Models –context-dir Data –namespace Northwind.Models –context-namespace Northwind.Data –context NorthwindContext -f –no-onconfiguring
Join this channel to get access to perks:
https://www.youtube.com/channel/UCetyodKOWGk5H6FoKoFnkZw/join
Subscribe here – https://www.youtube.com/channel/UCetyodKOWGk5H6FoKoFnkZw
Talk to us on – https://www.twitch.tv/curiousdrive
Like our page – https://www.facebook.com/curiousdrive/
Follow us on – https://twitter.com/curious_drive
Follow us on – https://www.instagram.com/curiousdrive/
Make a donation – https://www.paypal.me/curiousdrive
Be a member – https://www.patreon.com/curiousdrive
#CuriousDrive #WeLoveCoding
Comments are closed.