Using SQLite in-memory with EF Core – context.Database.EnsureCreated keeps throwing ‘AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY’
I am currently trying to write unit tests for a project in C# that relies heavily on Entity Framework Core. In order to do that I have decided to use a SQLite in-memory database, and taking inspiration from the example that can be found here, I have written the following class :
Using SQLite in-memory with EF-Core – context.Database.EnsureCreated keep throwing ‘AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY’
I am currently trying to write unit tests for a project in C# that relies heavily on EntityFrameworkCore. In order to do that I have decided to use a SQLite in-memory database, and, taking inspiration from the example that can be found here, I have written the following class :