When trying to use the code first approach of Entity Framework Core to generate database and tables using MySQL. When running Update-Database in the package console manager, it shows an error saying table __efmigrationhistory doesn’t exists.<\/p>\n\n\n\n
After digging in Stackoverflow, it seems that it’s a bug with the official MySQL connector. And at the time of this writing with this version 8.0.20 and .NET Core 3.1, this bug hasn’t been fixed. The connector is supposed to create this table for migration.<\/p>\n\n\n\n
https:\/\/stackoverflow.com\/a\/46090571\/9191495<\/a><\/p>\n\n\n\n In order to solve this problem there are two solutions<\/p>\n\n\n\n -Don’t use the official connector, use Pomelo.EntityFramework.MySql<\/p>\n\n\n\n https:\/\/www.nuget.org\/packages\/Pomelo.EntityFrameworkCore.MySql<\/a><\/p>\n\n\n\n -Alternatively create, the table yourself<\/p>\n\n\n\n It’s a waste of time, but what can one do.<\/p>\n","protected":false},"excerpt":{"rendered":" When trying to use the code first approach of Entity Framework Core to generate database and tables using MySQL. When running Update-Database in the package console manager, it shows an error saying table __efmigrationhistory doesn’t exists. After digging in Stackoverflow, it seems that it’s a bug with the official MySQL connector. And at the time … Continue reading “EF Core Update-Database failed with MySQL”<\/span><\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[98,105,106],"class_list":["post-726","post","type-post","status-publish","format-standard","hentry","category-problems","tag-asp-net-core","tag-entity-framework-core","tag-mysql"],"_links":{"self":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/726","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=726"}],"version-history":[{"count":1,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/726\/revisions"}],"predecessor-version":[{"id":727,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=\/wp\/v2\/posts\/726\/revisions\/727"}],"wp:attachment":[{"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=726"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=726"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bruceng.com\/dev\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=726"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}CREATE TABLE `__EFMigrationsHistory` \n( \n `MigrationId` nvarchar(150) NOT NULL, \n `ProductVersion` nvarchar(32) NOT NULL, \n PRIMARY KEY (`MigrationId`) \n);<\/code><\/pre>\n\n\n\n