Run database migrations using Entity Framework core on application start

Question

Is it possible to configure StartUp.cs or project.json to run database migrations using Entity Framework Core on application start?

Now I have middleware that do this task, but it seems to make negative influence on performance because database is being checked each request received.

public class EntityFrameworkUpdateDatabaseMiddleware
{
    private readonly RequestDelegate _next;
    private readonly ApplicationDbContext _dbContext;

    public EntityFrameworkUpdateDatabaseMiddleware(RequestDelegate next, ApplicationDbContext dbContext)
    {
        _next = next;
        _dbContext = dbContext;
    }

    public async Task Invoke(HttpContext context)
    {
        await _dbContext.Database.MigrateAsync();
        await _next.Invoke(context);
    }
}

Brad · Accepted Answer · 2016-07-09 14:57:57Z

15

You can do this in the config methods in your Startup.cs. The simplest way is like this:

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<ApplicationDbContext>();

    // add other services        
}

public void Configure(IApplicationBuilder app, ApplicationDbContext db)
{
    db.Database.Migrate();

    // configure other services
}

answered Jul 9, 2016 at 14:57

Brad

4,5632 gold badges19 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bastien Vandamme Over a year ago

Finally, something that is really improved from EF 6

Sras Over a year ago

is it override tables on production server?

bitmountain Over a year ago

For EF core, if the database migration project is created as a seperate project, configure the dbcontext with MigrationsAssembly options will make it work.

services.AddDbContext<SampleDbContext>(opt =>                opt.UseSqlServer(dbConnectionString,                                                                   x => x.MigrationsAssembly("SampleApi.DbMigration")));

Collectives™ on Stack Overflow

Run database migrations using Entity Framework core on application start

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related