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:
/channel/UCetyodKOWGk5H6FoKoFnkZw/join
Subscribe here - /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