EF数据迁相关资料

Add-Migration InitialCreate       --新增迁移脚本
Update-Database -Verbose     --执行迁移脚本

 

//过滤所有外键级联删除

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
var foreignKeys = modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys()).Where(fk => fk.DeleteBehavior == DeleteBehavior.Cascade);
foreach (var fk in foreignKeys)
fk.DeleteBehavior = DeleteBehavior.Restrict;

}

 

//设置索引，唯一索引，设置查询过滤字段

modelBuilder.Entity<Role>(entity =>
{
entity.HasIndex(e => e.RoleName).IsUnique();
entity.HasQueryFilter(e => e.IsDeleted == false);
});