EF Core - Table '*.__EFMigrationsHistory' doesn't exist

.net-core c# entity-framework entity-framework-core mysql

Question

I want to stress out that this is .NET Core and the threads about EF 6.0 does not apply to this problem

I created my DbContext and added it in DI, however when I do dotnet ef database update -v it does not want to create the migrations table __EFMigrationsHistory.

Is there some other command that I should do first or this is a bug of EF Core MySQL adapter?

MainDbContext

using Microsoft.EntityFrameworkCore;
using MySQL.Data.EntityFrameworkCore.Extensions;
using Web.Models;

namespace Web.Infrastructure
{
    public class MainDbContext : DbContext
    {
        public DbSet<User> Users { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            optionsBuilder.UseMySQL("connection-string-here");
            base.OnConfiguring(optionsBuilder);
        }
    }
}

Error

Finding DbContext classes...

Using context 'MainDbContext'.

Using database 'db' on server 'localhost'.

MySql.Data.MySqlClient.MySqlException: Table 'db.__EFMigrationsHistory' doesn't exist

Table 'db.__EFMigrationsHistory' doesn't exist

project.json

{
  "dependencies": {
    "Microsoft.NETCore.App": {
      "version": "1.0.1",
      "type": "platform"
    },
    "Microsoft.AspNetCore.Diagnostics": "1.0.0",
    "Microsoft.AspNetCore.Mvc": "1.0.1",
    "Microsoft.AspNetCore.Razor.Tools": {
      "version": "1.0.0-preview2-final",
      "type": "build"
    },
    "Microsoft.AspNetCore.Routing": "1.0.1",
    "Microsoft.AspNetCore.Server.IISIntegration": "1.0.0",
    "Microsoft.AspNetCore.Server.Kestrel": "1.0.1",
    "Microsoft.AspNetCore.StaticFiles": "1.0.0",
    "Microsoft.Extensions.Configuration.EnvironmentVariables": "1.0.0",
    "Microsoft.Extensions.Configuration.Json": "1.0.0",
    "Microsoft.Extensions.Logging": "1.0.0",
    "Microsoft.Extensions.Logging.Console": "1.0.0",
    "Microsoft.Extensions.Logging.Debug": "1.0.0",
    "Microsoft.Extensions.Options.ConfigurationExtensions": "1.0.0",
    "Microsoft.VisualStudio.Web.BrowserLink.Loader": "14.0.0",
    "BundlerMinifier.Core": "2.2.301",
    "WebMarkupMin.AspNetCore1": "2.2.1",
    "MySql.Data.EntityFrameworkCore": "7.0.6-IR31",
    "Microsoft.EntityFrameworkCore.Design": "1.0.0-preview2-final"
  },
  "tools": {
    "Microsoft.AspNetCore.Razor.Tools": "1.0.0-preview2-final",
    "Microsoft.AspNetCore.Server.IISIntegration.Tools": "1.0.0-preview2-final",
    "Microsoft.EntityFrameworkCore.Tools": "1.0.0-preview2-final"
  },
  "frameworks": {
    "netcoreapp1.0": {
      "imports": [
        "dotnet5.6",
        "portable-net45+win8"
      ]
    }
  },
  "buildOptions": {
    "emitEntryPoint": true,
    "preserveCompilationContext": true
  },
  "runtimeOptions": {
    "configProperties": {
      "System.GC.Server": true
    }
  },
  "publishOptions": {
    "include": [
      "wwwroot",
      "**/*.cshtml",
      "appsettings.json",
      "web.config"
    ]
  },
  "scripts": {
    "prepublish": [ "bower install", "dotnet bundle" ],
    "postpublish": [ "dotnet publish-iis --publish-folder %publish:OutputPath% --framework %publish:FullTargetFramework%" ]
  }
}

Temp Solution

By executing dotnet ef migrations script I get SQL code that I can execute directly in MySQL. After that migrations table is created and everything works normally. This is temp-solution which is bad. I still wonder what is the "correct" way of enabling migrations.

1
27
11/15/2016 9:07:27 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Turning Mark G's comment into an answer.

Once the __EFMigrationsHistory table has been created, the rest of the update should run.

CREATE TABLE `__EFMigrationsHistory` ( `MigrationId` nvarchar(150) NOT NULL, `ProductVersion` nvarchar(32) NOT NULL, PRIMARY KEY (`MigrationId`) );

Alternatively, generate the script of your migration(s) and apply to the database manually using this command in Package Manager Console:

Script-Migration

If you need to generate All scripts, you can use this command:

Script-Migration -from 0
46
3/22/2017 2:51:13 PM

Popular Answer

Encountered the same problem while using standard Oracle provider.

According to this question Dot Net Entity Framework database update doesn't create tables in mysql database it doesn't have the migrations feature implemented yet.

I followed the suggestions the switched to SapientGuardian provider and it does seem to be the best way to go now.

Edit: as suggested in comments Pomelo is the best option as of beggining of 2018. I've chosen it over other providers since my original answer.

Peuczynski

Related Questions

Table 'DBNAME.dbo.TableNAME' doesn't exist Entity Framework 6 with MySQL

class SqlGenerator : MySql.Data.Entity.MySqlMigrationSqlGenerator { public override IEnumerable<MigrationStatement> Generate(IEnumerable<MigrationOperation> migrationOperations, string providerManifestToken) { IEnumerable < MigrationStatement > res = base.Generate(migrationOperations, providerManifestToken); foreach(Migrati...
c# entity-framework entity-framework-6 mysql
asked by Michał B

Entity Framework Core - change schema of "__EFMigrationsHistory" table

Looking into source code (...HistoryRepository.cs...). You can configure custom migrations table and schema names, inside ...DbContext constructor...public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options) { var relationalOptions = RelationalOptionsExtension.Extract(options); relationalOptions.MigrationsHi...
entity-framework-core
asked by tmg

EF Core `update-database` on MySql fails with `__EFMigrationsHistory' doesn't exist`

I Create new project in .net core 1.1 with individual user account identity. I Add MySql Provider in Startup.cs:...services.AddDbContext<ApplicationDbContext>(options => options.UseMySQL(Configuration.GetConnectionString("DefaultConnection"))); ...But when i try do ...update-database... i get error like this:...MySql.Data.MySqlClient.MySql...
asp.net-core c# entity-framework entity-framework-core mysql
asked by R.Prog

Add pre-existing table to code-first migration in EF Core 2.0

I want to add a table that already exists in my SQL Server database to a ...DbContext... that I have so far only used for code-first migrations using Entity Framework Core 2.0. ...Is there a way for me to create a model class, add a ...DbSet<T>... to the ...DbContext... descendant and have it "hook-up" with the table in the database without messing...
.net-core c# entity-framework entity-framework-core entity-framework-core-migrations
asked by Minustar

Using automapper.collection in aspnet core & ef core doesn't updated edited records in a collection

I'm using asnet boilerplaite aspnet core and ef core. I've initialized automapper.collection in PreInitialize as follows:...Configuration.Modules.AbpAutoMapper().Configurators.Add( cfg =>{ cfg.AddCollectionMappers(); cfg.CreateMap<OrderDTO, Order>().EqualityComparison((odto, o) => odto.ID == o.ID); cfg.CreateMap<OrderIte...
asp.net-core aspnetboilerplate automapper collections entity-framework-core
asked by DLedge

Attempting to create ASP.Net Core Identity data in an existing table with existing user records

I have a new ASP.Net Core website that uses an existing database, to which I have added ASP.Net Core Identity for user management. ...Since there is an existing user table, I simply added the which I have properly added the ASP.Net identity columns. ...The additional columns in the existing table are in my IdentityUser-derived class. The site ...
asp.net-core asp.net-core-identity c# entity-framework-core
asked by Ev Conrad

EF Core Create a field that doesn't exist

I'm using Entity Framework Core - Code First to load data from a SQLite file. The problem is I updated the schema of the new SQLite DB files and added fields in a table. It works fine for the newly generated DB. but, when I try to open an old file, I got an exception. I don't really understand EF. I need help cause I have 2 questions :...Is it pos...
c# entity-framework entity-framework-core sqlite
asked by T00rk

Check if a table exists using EF Core 2.1

In Entity Framework the existence of a table can be checked this way:...bool exists = context.Database .SqlQuery<int?>(@" SELECT 1 FROM sys.tables AS T INNER JOIN sys.schemas AS S ON T.schema_id = S.schema_id WHERE S.Name = 'SchemaName' AND T.Name = 'TableName'") ...
c# entity-framework entity-framework-core
asked by AndreFeijo

Model column doesn't exist in __EFMigrationsHistory of EF Core

I am working with EF Core in Code-First approach. Everything is working well as like EF 6.0 for migration, creating tables, relationships, etc. But, one thing missing with __EFMigrationsHistory table, there should be a column 'Model' to store binary data of migration. Model column was not created when I run update-database command. Please check min...
entity-framework entity-framework-core
asked by sebu

How add tables to existing EF Core 3.0 context by PM console?

you were close! You should specify -t for each table so in your case it will be:...`Scaffold-DbContext "Server=dbServer;Database=myAppDb;User Id=UserAppdb; Password=MyPass;" Microsoft.EntityFrameworkCore.SqlServer -o Models -t Users -t Devices -t Items -context "AppdbContext"`
asp.net-core c# entity-framework-core
asked by Pablokuko

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow