我运行了一次迁移(使用Fluent Migrator),并注意到我在外键上的表名上犯了一个错误。
我怎么才能修复它呢?我是否应该运行新的迁移?
public class AdditionalCosts : Migration
{
public override void Up()
{
Create.Table("AdditionalCosts").WithColumn("ID").AsInt32().PrimaryKey().Identity()
.WithColumn("DocTypeID").AsInt32().NotNullable()
.WithColumn("Cost").AsInt32().NotNullable()
.WithColumn("CreatedAt").AsDateTime().Nullable().WithDefault(SystemMethods.CurrentDateTime)
.WithColumn("AddedBy").AsString().Nullable()
.WithColumn("ModifiedAt").AsDateTime().NotNullable().WithDefault(SystemMethods.CurrentDateTime)
Create.ForeignKey()
.FromTable("AdditionalCosts").ForeignColumn("DocTypeID")
.ToTable("Documents").PrimaryColumn("ID");
}
public override void Down()
{
Delete.Table("AdditionalFees");
}
}外键应该是(不同的ToTable):
Create.ForeignKey()
.FromTable("AdditionalCosts").ForeignColumn("DocTypeID")
.ToTable("DocumentTypes").PrimaryColumn("ID");发布于 2019-01-30 03:09:17
感谢@Liam,我能够通过运行以下命令回滚到上一次迁移:
dotnet fm rollback -c ';Persist Security Info=True;User ID=test;Password=test; Initial Catalog=test;Data Source=.\SQLEXPRESS' -p SqlServer -a ./Project.Data/bin/Debug/netcoreapp2.2/Project.Data.dll to 20190123125705 --migration versionhttps://stackoverflow.com/questions/54419305
复制相似问题