How to set threading mode in SQLite with Entity Framework?

Thread safe Entity Framework 6

Just starting testing EF6 and its Async functions. Boy was I surprised when I realized that they are not thread safe. I kinda assumed that that was the point....I had my own ...Task... based extension methods for years already, but what I was waiting for from EF was to make them thread safe....At least my Task based functions ...lock...ed as to not...

Entity Framework will only set related entity property to "null" if I first get the property

Edit... This seems to occur for ...any... Entity property that references another entity in one direction. In other words, for the below example, the fact that ...Bar... overrides Equality appears to be irrelevant....Suppose I have the following classes:...public class Foo { public int? Id { get; set; } public virtual Bar { get; set; } }...

Setting journal mode in SQLite for Entity Framework Core code-first

I'm using DBContext on Entity Framework, using a process like ...in this tutorial... to create the DB....public class BloggingContext : DbContext { public DbSet<Blog> Blogs { get; set; } protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlite("Filename=blog.db"); } } ...and s...

EntityFramework Core Unit Testing - SQLite in-memory mode vs. The InMemory provider

I am in a process of writing unit tests for a project that uses EntityFramework Core and according to the ...docs... I can use ...SQLite in-memory mode... or ...The InMemory provider... to approximate the database context....The docs states that the ...SQLite in-memory mode... behaves like a relational database and that ...The InMemory provider... ...

Entity Framework Core - Not thread safe - ServiceLifetime.Transient

Also note that in Microsoft Dependency Injection, transient services will not be disposed until the scope ends. ...There is a clean way around this which is to use a WeakReference as the Transient instead of TService. The user of the WeakReference can then take responsibility for Dispose.

Setting SET IDENTITY_INSERT for multiple tables in Entity Framework Core

I want to set tables ...IDENTITY_INSERT... to ...ON.... I can for one table at a time. But how can I achieve for more than one as I am doing code-first approach....I'm getting this error:...System.Data.SqlClient.SqlException : IDENTITY_INSERT is already ON for table 'Some Table'. Cannot perform SET operation for table 'ref.EmploymentType'...Test.cs...

DBContext System.ObjectDisposed Exception with .NET Entity Framework Core, Dependency Injection and threading

AddDbContext<>()... registers the ...MyDBContext... as a service with ...ServiceLifetime.Scoped... which means that your ...DbContext... is created per web request. It is disposed when request is completed....The easiest way to avoid that exception is inject ...IServiceScopeFactory... into your controller, then create a new scope using ...CreateSco...

Entity Framework Core setting owned entity null when added

I have the following graph:...public class Report { public Guid Id { get; set; } public ICollection<EmployeeEntry> EmployeeEntries { get; set; } } public class EmployeeEntry { public Guid Id { get; set; } public DateTimeOffset EntryDate { get; set; } public Address Address { get; set; } } public class Address { public stri...

Entity Framework Core: different threads using the same instance of DbContext

The application was developed on ASP NET Core 3. To log user actions, I decided to use a single method in the Project class. Faced the problem of using one singleton dbContext from different threads....Startup.cs...public void ConfigureServices(IServiceCollection services) { string connection = Configuration.GetConnectionString("ConnectionDB");...

How to automatically set CreatedOn fields with Entity Framework on saved entity and its child properties

Whenever I call ...databaseContext.SaveChanges()..., before data is saved by Entity Framework, I need all objects and their child classes to have the ...CreatedOn... field populated with ...DateTime.Now().......Details: I have a ...BaseEntity... class that all entities inherit from:... public class BaseEntity { [Key] public virtual...