问题描述
我首先在 ASP.Net Identity 1.0 中使用 MVC5 + Ef6 代码,并希望在自定义模式中创建表.即不是 dbo 架构的架构.
I am using MVC5 + Ef6 code first with ASP.Net Identity 1.0 and wish to have the tables created in a custom schema. i.e. a schema that is not the dbo schema.
我使用 Ef 电动工具对我的数据库进行逆向工程,并将映射类中所有其他表的模式名称设置为以下
I reversed engineered my databse using the Ef power tools and set the schema name for all other tables in the mapping class to the following
this.ToTable("tableName", "schemaName");
我尝试为 ASP.Net 表执行此操作,但它不断给我很多错误,最终我放弃了.如果我从我的项目中排除(逆向工程)ASP.Net Identity 表,它们将被创建但始终在 dbo 架构中
I tried doing this for the ASP.Net tables but it kept giving me a lots of errors and eventually I gave up. If I exclude the (reverse engineered) ASP.Net Identity tables from my project they will be created but always in the dbo schema
有人知道怎么做吗?
推荐答案
public class MyDbContext : EntityDbContext<ApplicationUser>
{
public DbSet<ApplicationUser> Users { get; set; }
public MyDbContext() : base()
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
base.OnModelCreating(modelBuilder);
// You can globally assign schema here
modelBuilder.HasDefaultSchema("schemaName");
}
}
这篇关于ASP.Net Identity - 使用自定义架构的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!