Entity Framework Core not creating database on update-database

Question

I'm trying to generate my database using code-first. When I run the command update-database, I receive that database cannot be null, but I expected that database would be automatically created. Any idea what I am missing?

        services.AddControllers();
    }

    public class SmartSchoolContext : DbContext
    {
        public DbSet<Aluno> Alunos { get; set; }
        public DbSet<Professor> Professores { get; set; }
        public DbSet<Disciplina> Disciplinas { get; set; }
        public DbSet<AlunoDisciplina> AlunosDisciplinas { get; set; }

        public SmartSchoolContext(DbContextOptions options) : base(options)
        {
        }

    }
}

public void ConfigureServices(IServiceCollection services)
{
    services.AddDbContext<SmartSchoolContext>(context => context.UseMySQL(Configuration.GetConnectionString("Default")));
    services.AddControllers();
}

To start with, I cleaned up your post but it appears you didn't paste part of the code at the beginning there. — Jeremy Harris
– Jeremy Harris, Commented Dec 17, 2020 at 15:16
What's the exact command you are running? Are you adding any arguments? — Carl
– Carl, Commented Dec 17, 2020 at 15:21
Does this answer your question? Not creating database using Migration command Update-Database in ASP.Net Core 2 — Lukasz Szczygielek
– Lukasz Szczygielek, Commented Dec 17, 2020 at 15:22

hemant duvey · Accepted Answer · 2020-12-17 16:34:53Z

0

in startup.cs>>ConfigureServices method you have to add

services.AddDbContext<SmartSchoolContext>();

in configure method:

public void Configure(IApplicationBuilder app, IWebHostEnvironment env, DataContext context)
{
   // migrate database changes on startup (includes initial db creation)
        context.Database.Migrate();
   // other logic

}

note:: add and update database using command make sure your database connection is open

edited Dec 17, 2020 at 16:34

answered Dec 17, 2020 at 16:27

hemant duvey

194 bronze badges

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

1 Comment

Eric J. Over a year ago

I wouldn't recommend automatically migrating the database in production code. The database login the public-facing application is using should generally not have DDL (data definition language) permissions.

Collectives™ on Stack Overflow

Entity Framework Core not creating database on update-database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related