SQLite + EF Core + ASPNET Core Web API + CRUD + Views + Loading Related Data



SQLite + EF Core + ASPNET Core Web API + CRUD + Views + Loading Related Data

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.