Auto create tables (Code first) using Entity Framework WITH MYSQL

Question

I'm writing this post because I need help with my ASP.NET Core MVC application. I'm using Entity Framework with Identity

This is the dbcontext class. The Settings DbSet is only for testing. Here Identity must create automatically all the tables such as AspNetUsers, AspNetRoles, etc as it does with a Sql Server, that is called

Code First if I am not wrong.

public class ApplicationDbContext : IdentityDbContext<ApplicationUser>
    {
        public DbSet<SettingsDataModel> Settings { get; set; }

        public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options) : base(options)
        {

        }
        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            // Fluent API
            modelBuilder.Entity<SettingsDataModel>().HasIndex(a => a.Name);
        }
    }

So, there I create the database class, the ASP.NET app inits the database here:

        services.AddDbContext<ApplicationDbContext>(options =>
                options.UseMySQL(IoCContainer.Configuration.GetConnectionString("DefaultConnection")));


        services.AddIdentity<ApplicationUser, IdentityRole>()
                .AddEntityFrameworkStores<ApplicationDbContext>()
                .AddDefaultTokenProviders();

In the Startup class. Note I'm using MySql because I will host the application in an App Engine on Google Cloud Platform, that is why the code has .UseMySQL. And in the HomeController is where I execute EnsureCreated method.

    protected ApplicationDbContext mContext;

    protected UserManager<ApplicationUser> mUserManager;

    protected SignInManager<ApplicationUser> mSignInManager;

    public HomeController(
        ApplicationDbContext context,
        UserManager<ApplicationUser> userManager,
        SignInManager<ApplicationUser> signInManager)
    {
        mContext = context;
        mUserManager = userManager;
        mSignInManager = signInManager;
    }

    public IActionResult Index()
    {
        mContext.Database.EnsureCreated(); //<-- It returns false

        if (!mContext.Settings.Any()) //<-- Here it throws an exception saying that the database no exists
        {
            mContext.Settings.Add(new SettingsDataModel
            {
                Name = "BackgroundColor",
                Value = "Red"
            });

            mContext.SaveChanges();
        }

        return View();
    }

I hope I explained correctly and I provided all needed classes to solve the problem.

Update-Database to apply pending migrations to the database — ElasticCode
– ElasticCode, Commented Apr 13, 2018 at 22:36
Check this answer for apply pending migrations to the database. — ElasticCode
– ElasticCode, Commented Apr 13, 2018 at 22:42
Yes, I used it. I migrated the database and I updated it. Identity tables was created, the problem now is that when I want to create new DbContexts with DbSets, it never gets created. I use mContext.Database.EnsureCreated(); but I doesn't create new tables — user7700551
– user7700551, Commented Apr 13, 2018 at 22:47

ElasticCode · Accepted Answer · 2018-04-13 22:56:43Z

2

In your ApplicationDbContext class make sure you add all needed class as public property like Settings Table.

public DbSet<PeopleDataModel> People { get; set; }

After that, you need to run Add-Migration AddPeople command that will create a new migration class with new changes, then run Update-Database command to apply pending migrations to the database.

answered Apr 13, 2018 at 22:56

ElasticCode

7,9252 gold badges38 silver badges49 bronze badges

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

Collectives™ on Stack Overflow

Auto create tables (Code first) using Entity Framework WITH MYSQL

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related