Entity Framework Core - Knowledge Base (KB)

SQLite in ASP.NET Core with EntityFrameworkCore

How do you add and use an SQLite database in an ASP.NET Core web application, using EntityFramework 7 ?...I dived into ASP.NET Core the moment I heard about it and created my first web application, I suddenly had a bunch of data that I wanted to store and...

EF Core - dropping a column workaround (sqlite)

It ...is documented... and known that EF core migration scripts don't support dropping a column. So I'm trying to do it by hand....My model classes are:...class Master { public int Id { get; set; } public string ToBeDeleted { get; set; } } class ...

Unable to determine the provider name for provider factory of type “System.Data.Sqlite.SqliteFactory”

Unexpected exception occurred when generating the model. See output window for more details. Exception message: 'NotSupportedException: Unable to determine the provider name for provider factory of type 'System.Data.SQLite.SQLiteFactory'. Make sure that t...

.NET Core EF6 error with SQLite connection string

I can't seem to pass parameters to sqlite connection string ......If I do:... public class MyDbContext : DbContext { public DbSet<MyData> MyData { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { o...

Sqlite DB Locked on Azure Dotnet Core Entity Framework

I have a simple asp.net core web app (v2.1), that I deployed to a B1 (and I tried B2) Azure App Service on Linux. When I call ...dbContext.SaveChanges()..., after adding one very simple entity, the request takes about 30 seconds before throwing the follow...