重置Entity framework code first数据库

误删了数据库中表，不能用命令行迁移了，只能重新生成数据库，真是精疲力尽，数据全部丢失

public EFMySqlContext() : base("EFMySqlContext")
{
System.Data.Entity.Database.SetInitializer(new System.Data.Entity.DropCreateDatabaseAlways<EFMySqlContext>());
}

改成命令行工程

static void Main(string[] args) {
using(EFMySqlContext context =new EFMySqlContext())
{
Friends_Entity friend = new Friends_Entity();
friend.FriendId = 1;
friend.UserId = 2;
context.Friends.Add(friend);
}

}

 

internal sealed class Configuration : DbMigrationsConfiguration<EFMysqlLib.EFMySqlContext>
{
public Configuration()
{
AutomaticMigrationsEnabled = true;
}