我需要在运行时创建模式,并将现有的表复制到那里。DbContext:
public class TenantContext : DbContext
{
public TenantContext(string schemaName)
{
this.SchemaName = schemaName;
}
public string SchemaName { get; set; }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
base.OnConfiguring(optionsBuilder);
optionsBuilder
.UseSqlServer("connString");
}
public virtual DbSet<TestEntity> TestEntities { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
modelBuilder.Entity<TestEntity>().ToTable("TestEntity", SchemaName);
}
}架构创建:
public void CreateSchema(SchemaRequest req)
{
TenantContext context = new TenantContext(req.Name);
RelationalDatabaseCreator creator =
(RelationalDatabaseCreator) context.Database.GetService<IRelationalDatabaseCreator>();
creator.CreateTables();
}当我尝试测试它时,我创建了"schema1.TestEntity",当我尝试创建"schema2.TestEntity“时,它给了我System.Data.SqlClient.SqlException: 'There is already an object named 'TestEntity' in the database.'。然而,当我重新启动应用程序并再次尝试创建"schema2.TestEntity”时,它工作得很好,但当我试图创建第三个模式时,它却出现了同样的错误。我做错了什么?
发布于 2019-01-14 18:53:33
您正在创建相同的表,因此ef检测到您已经拥有该表,并且不允许您拥有重复的表。
https://stackoverflow.com/questions/54179867
复制相似问题