entity framework 5 codefirst with mysql

Question

can ef5 work with mysql when using code first approach? when i'm trying to add new items to a not yet created table I'm getting "Table 'clients' doesn't exist. if I'm switching to mssql everything works well.

this is my dbcontext

    public class MyDBContext : DbContext
{
    public PowerToolsDBContext()
        : base("Name=MyContext") { }

    public DbSet<User> Users { get; set; }
    public DbSet<Client> Clients { get; set; }
    public DbSet<JobData> Jobs { get; set; }
}

Reem Dayan · Accepted Answer · 2013-11-17 08:27:33Z

1

Problem solved after adding database initializer

 static MyDBContext()
    {
        Database.SetInitializer<MyDBContext>(new DropCreateDatabaseIfModelChanges<MyDBContext>());
    }

edited Nov 17, 2013 at 8:27

answered Nov 17, 2013 at 8:21

Reem Dayan

113 bronze badges

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

Collectives™ on Stack Overflow

entity framework 5 codefirst with mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related