EF Error SQLite Error 1: 'no such table: __EFMigrationsHistory'. when i run dotnet ef databas update
iam using linux and vs code .Net 7 was following this tutorial https://www.youtube.com/watch?v=PDiRDNNc2tw&t=394s and ran into this issue
Patrick God
YouTube
.NET 6 š EF Core & SQLite with Code First Migrations
š .NET Jumpstart Course: https://www.udemy.com/course/net-core-31-web-api-entity-framework-core-jumpstart/?couponCode=DOTNET6YT
š§ Newsletter: https://newsletter.patrickgod.com/
ā¤ļø Ko-fi: https://ko-fi.com/patrickgod
ā Coffee: https://www.buymeacoffee.com/patrickgod
š» GitHub: https://github.com/patrickgod/EF6SQLiteTutorial
š¦ Twitter: https://twi...
11 Replies
running the initial migration should create that table
I am having this exact issue!!
add-migration works but then update-database always fails with error 14
it doesnt
migration will run but the update wont
curious
I get one in mine when I generate and run my initial migration
however, its a very simple table to create manually
its called
__EFMigrationsHistory with two underscores, it has two columns: MigrationId and ProductVersion, both TEXT (in SQLite)where would i create in manually ?
in the database?
But you are letting EFCore do everything, right? Including creating the sqlite file itself?
Just dont understand why it wouldnt create the history table O_o
it wont even create the db
yes
it wont create the db file as well
can you jump on screenshare and show me?
this sounds wack
gladly
thank you for the help
#dev-vc-1
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.