ASP.Net Identity - 使用自定义架构 [英] ASP.Net Identity - Use custom Schema

问题描述

我首先在 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 - 使用自定义架构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！