SQLite Error 14: 'unable to open database file' with EF Core code first
ef-code-first entity-framework-core sqlite
Question
I am getting an
SQLite Error 14: 'unable to open database file'
with EF Core code first, no idea why. I worked fine the first time, the database file got created in c:\users\username\AppData\Local\Packages\PackageId\LocalState.
Then I deleted the database file and the code first migration and ModelSnapshot classes and created a new migration (I am calling DbContext.Database.Migrate() on app start to automatically execute them). Now the database cannot be created again.
Popular Answer
i think the issue is that the EntityFramework Core can't create folders by itself while using SQLite provider. Don't know if the issue also appears when using other filebased database providers.
i had the same issue:
my datasource was something like:
optionsBuilder.UseSqlite(@"Data Source=c:\foo_db\bar_db.db");
after i created the "foo_db" folder inside the c:\ drive, the problem was solved and EF Core created the .db file inside the folder.
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow