Add Sqlite database using EF Core code-first in ASP.NET CORE 5+, 6

Показать описание

In this quick code hack moment video, we demonstrate how to easily add a local Sqlite database file to an ASP.NET Core 5+, 6 project using EF Core code-first. This code hack moment is part of a larger project demonstrating Authentication/Authorization in ASP.NET Core 5+, 6.

Code hack moments are not intended to be a complete tutorial, but is a "gist" to show how to do one particular thing.

Рекомендации по теме

Комментарии

Thanks a lot for this video. Has covered all my questions.

ak

Do you have any idea how to fix this error: "MSBuild Error MSB4006"
I have faced to this error while I wanted to run this command
dotnet ef migrations add initial -o Data

PiratesK

Thanks for the video. Great information.

jspencer

Hello. Thank you for the video :)
I'm wondering why AppUser is in Data folder - what about the Models folder?
If I have more classes (more database tables) can I just add them to Models and then mention at the top of AuthDbContext as DbSet before I do Code First?

katarzynakowalczyk

I didnt understand the OnModelCreating part. Do we need to do that for every model that we plan to update the database with?

helderperez

How can I have package manager console in visual studio code. please help.

kaulshrutikrishnakumar

Thank you for this video, it is again great and valuable informations.
Do you plan to do more videos to improve the cookie authentication for exemple with best practices for password encryption with salt, storing roles, ... ?

I know Identity exist, but i don't like it.

Camille-jmoe

Add Sqlite database using EF Core code-first in ASP.NET CORE 5+, 6

Add Sqlite database using EF Core code-first in ASP.NET CORE 5+, 6

Adding a SQLite Database using EF Core - Make a Modern WPF Desktop App Part 9

.NET 6 🚀 EF Core & SQLite with Code First Migrations

Setup SQLite Database in Visual Studio (14/23)

Inserting Data Into Our SQLite Database - Make a Modern WPF Desktop App Part 10

.NET 6 - ASP.NET core MVC - (Add database - SQLITE)

Connect to SQLite using EF Core

How do I use C# and .NET with SQLite?

How to Create Sqlite Database using EntityFramework in UWP

How to Create a SQLite Database with Entity Framework Core in an ASP.NET Core MVC WebApp! #1

C# CRUD Operations With SQLite Database Using Entity Framework

UWP, SQLite & EF Core Part 1 - Create UWP, .Net Standard and .Net Core projects

Query SQLite database using .NET Entity Framework Core 7

ASP.Net Core MVC - Use SQLite With Entity Framework Core

Blazor Application - CRUD using SQLite and EntityFrameworkCore

UWP, SQLite & EF Core Part 2 - Create database model with code first approach

How to Integrate SQLite Database with EF Core in .Net MAUI App with Code First Migrations

Create Sqlite DataBase Using efcore and Blazor in 5 minute

Xamarin CRUD operation using SQLite (EntityFramework)

Update Data into SQLite Database using Entity Framework Core in .NET 6 Windows Forms

SQLite and Entity Framework Core in Blazor (Create Database & table, Insert & Select Operati...

UWP, SQLite & EF Core Part 4 - Add code behind and execute the app

UWP, SQLite & EF Core Part 3 - Add UI

How to use Entity Framework Core with SQLite