ApplicationUser DbContext与My DBcontext合并

Question

我现在意识到，我有一个应用程序，它愚蠢地有两个独立的DBcontexts，它们需要合并，以便允许应用程序实体和ApplicationUser实体之间的关系。

在应用程序的开发过程中，我相信在其他类中对applicationUser的引用为我的DBcontext上的ApplicationUser实体创建了表，而在不同的连接字符串和上下文上存在用于AspUserIdentity等的表。

我试图删除原始上下文并合并这两个上下文，但是当尝试创建迁移时，它希望将当前上下文中的所有现有ApplicationUser表重命名为AspUserIdentity等(见下文)。

如何成功地合并上下文，或者是否有其他解决方案？

我不知道该发布什么，但我会尝试张贴我认为是相关的，然后，如果有人需要更多的信息，请随时请求。

这是尝试合并之后的所有代码。(使用这个问题的答案之一：Merge MyDbContext to Asp.net IdentityDbContext中的指南)

我的上下文有以下表: ApplicationUsers IdentityRoles IdentityUserClaims IdentityUserLogins IdentityUserRoles

原始上下文有以下表，迁移正在尝试重命名上述表以匹配这些表: AspNetRoles AspNetUserClaims AspNetUserLogins AspNetUserRoles AspNetUsers

我的上下文：(注释的Modelbuilder语句导致多重错误)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

using System.Data.Entity;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Configuration;
using System.Web.Mvc;
using Microsoft.AspNet.Identity.EntityFramework;
using System.Data.Entity.ModelConfiguration.Conventions;
using eCommSite.Models;
using System.Data.Entity.Infrastructure;

namespace eCommSite.Areas.Admin.Models
{
    public class TheDBContext : IdentityDbContext 
    {

        public TheDBContext()
                : base(ConfigurationManager.ConnectionStrings["DataDBString"].ConnectionString)
            {
                var objectContext = (this as IObjectContextAdapter).ObjectContext;

                // Sets the command timeout for all the commands
                objectContext.CommandTimeout = 360;
            }
        public DbSet<ProductBase> ProductBases { get; set; }
        public DbSet<Address> Addresses { get; set; }
        public DbSet<PromotionImage> PromotionImages { get; set; }
        public DbSet<Image> Images { get; set; }
        public DbSet<ImageCollection> ImageCollections { get; set; }
        public DbSet<Order> Orders { get; set; }
        public DbSet<OrderLine> OrderLines { get; set; }
        public DbSet<ProductOption> ProductOptions { get; set; }
        public DbSet<ProductOptionType> ProductOptionTypes { get; set; }
        public DbSet<ProductType> ProductTypes { get; set; }
        public DbSet<FilterValueEntry> FilterValueEntries { get; set; }
        public DbSet<FilterType> FilterTypesDB { get; set; }
        public DbSet<CardBaseSummary> CardBaseSummarys { get; set; }
        public DbSet<ProductBaseSummary> ProductBaseSummaries { get; set; }
        public DbSet<Category> Categories { get; set; }
        public DbSet<Brand> Brands { get; set; }
        public DbSet<MMHPriceEntry> MMHPriceEntries { get; set; }
        public DbSet<Legality> Legalities { get; set; }
        public DbSet<ForeignName> ForeignNames { get; set; }
        public DbSet<SKUStockQuantity> SKUStockQuantities { get; set; }
        public DbSet<Location> Locations { get; set; }
        public DbSet<Cart> Carts { get; set; }
        public DbSet<StockCollection> StockCollections { get; set; }

        public static TheDBContext Create()
        {
            return new TheDBContext();
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);

            modelBuilder.Conventions.Remove<ManyToManyCascadeDeleteConvention>();
            modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();


          //  modelBuilder.Entity<IdentityUserLogin>().HasKey<string>(l => l.UserId);
          //  modelBuilder.Entity<IdentityRole>().HasKey<string>(r => r.Id);
         //   modelBuilder.Entity<IdentityUserRole>().HasKey(r => new { r.RoleId, r.UserId });

        }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.ApplicationUser> ApplicationUsers { get; set; }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.ProductRelation> ProductRelations { get; set; }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.MTG_Cards> MTG_Cards { get; set; }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.MTG_Set> MTG_Set { get; set; }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.ProductOptionValue> ProductOptionValues { get; set; }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.SKU> SKUs { get; set; }

        public System.Data.Entity.DbSet<eCommSite.Areas.Admin.Models.MMHsetToJsonSetReference> MMHsetToJsonSetReferences { get; set; }

    }
}

移民：

namespace eCommSite.Migrations
{
    using System;
    using System.Data.Entity.Migrations;

    public partial class MergeMigration : DbMigration
    {
        public override void Up()
        {
            RenameTable(name: "dbo.ApplicationUsers", newName: "AspNetUsers");
            RenameTable(name: "dbo.IdentityUserClaims", newName: "AspNetUserClaims");
            RenameTable(name: "dbo.IdentityUserLogins", newName: "AspNetUserLogins");
            RenameTable(name: "dbo.IdentityUserRoles", newName: "AspNetUserRoles");
            RenameTable(name: "dbo.IdentityRoles", newName: "AspNetRoles");
            DropIndex("dbo.AspNetUserClaims", new[] { "ApplicationUser_Id" });
            DropIndex("dbo.AspNetUserLogins", new[] { "ApplicationUser_Id" });
            DropIndex("dbo.AspNetUserRoles", new[] { "ApplicationUser_Id" });
            DropIndex("dbo.AspNetUserRoles", new[] { "IdentityRole_Id" });
            DropColumn("dbo.AspNetUserClaims", "UserId");
            DropColumn("dbo.AspNetUserLogins", "UserId");
            DropColumn("dbo.AspNetUserRoles", "UserId");
            DropColumn("dbo.AspNetUserRoles", "RoleId");
            RenameColumn(table: "dbo.AspNetUserClaims", name: "ApplicationUser_Id", newName: "UserId");
            RenameColumn(table: "dbo.AspNetUserLogins", name: "ApplicationUser_Id", newName: "UserId");
            RenameColumn(table: "dbo.AspNetUserRoles", name: "ApplicationUser_Id", newName: "UserId");
            RenameColumn(table: "dbo.AspNetUserRoles", name: "IdentityRole_Id", newName: "RoleId");
            DropPrimaryKey("dbo.AspNetUserLogins");
            DropPrimaryKey("dbo.AspNetUserRoles");
            AddColumn("dbo.AspNetUsers", "Discriminator", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUsers", "Newsletter", c => c.Boolean());
            AlterColumn("dbo.AspNetUsers", "RewardPoints", c => c.Int());
            AlterColumn("dbo.AspNetUsers", "BasketId", c => c.Int());
            AlterColumn("dbo.AspNetUsers", "BuylistBasketId", c => c.Int());
            AlterColumn("dbo.AspNetUsers", "StoreCredit", c => c.Double());
            AlterColumn("dbo.AspNetUsers", "Email", c => c.String(maxLength: 256));
            AlterColumn("dbo.AspNetUsers", "UserName", c => c.String(nullable: false, maxLength: 256));
            AlterColumn("dbo.AspNetUserClaims", "UserId", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUserClaims", "UserId", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUserLogins", "LoginProvider", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUserLogins", "ProviderKey", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUserLogins", "UserId", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUserRoles", "UserId", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetUserRoles", "RoleId", c => c.String(nullable: false, maxLength: 128));
            AlterColumn("dbo.AspNetRoles", "Name", c => c.String(nullable: false, maxLength: 256));
            AddPrimaryKey("dbo.AspNetUserLogins", new[] { "LoginProvider", "ProviderKey", "UserId" });
            AddPrimaryKey("dbo.AspNetUserRoles", new[] { "UserId", "RoleId" });
            CreateIndex("dbo.AspNetUsers", "UserName", unique: true, name: "UserNameIndex");
            CreateIndex("dbo.AspNetUserClaims", "UserId");
            CreateIndex("dbo.AspNetUserLogins", "UserId");
            CreateIndex("dbo.AspNetUserRoles", "UserId");
            CreateIndex("dbo.AspNetUserRoles", "RoleId");
            CreateIndex("dbo.AspNetRoles", "Name", unique: true, name: "RoleNameIndex");
        }

        public override void Down()
        {
            DropIndex("dbo.AspNetRoles", "RoleNameIndex");
            DropIndex("dbo.AspNetUserRoles", new[] { "RoleId" });
            DropIndex("dbo.AspNetUserRoles", new[] { "UserId" });
            DropIndex("dbo.AspNetUserLogins", new[] { "UserId" });
            DropIndex("dbo.AspNetUserClaims", new[] { "UserId" });
            DropIndex("dbo.AspNetUsers", "UserNameIndex");
            DropPrimaryKey("dbo.AspNetUserRoles");
            DropPrimaryKey("dbo.AspNetUserLogins");
            AlterColumn("dbo.AspNetRoles", "Name", c => c.String());
            AlterColumn("dbo.AspNetUserRoles", "RoleId", c => c.String(maxLength: 128));
            AlterColumn("dbo.AspNetUserRoles", "UserId", c => c.String(maxLength: 128));
            AlterColumn("dbo.AspNetUserLogins", "UserId", c => c.String(maxLength: 128));
            AlterColumn("dbo.AspNetUserLogins", "ProviderKey", c => c.String());
            AlterColumn("dbo.AspNetUserLogins", "LoginProvider", c => c.String());
            AlterColumn("dbo.AspNetUserClaims", "UserId", c => c.String(maxLength: 128));
            AlterColumn("dbo.AspNetUserClaims", "UserId", c => c.String());
            AlterColumn("dbo.AspNetUsers", "UserName", c => c.String());
            AlterColumn("dbo.AspNetUsers", "Email", c => c.String());
            AlterColumn("dbo.AspNetUsers", "StoreCredit", c => c.Double(nullable: false));
            AlterColumn("dbo.AspNetUsers", "BuylistBasketId", c => c.Int(nullable: false));
            AlterColumn("dbo.AspNetUsers", "BasketId", c => c.Int(nullable: false));
            AlterColumn("dbo.AspNetUsers", "RewardPoints", c => c.Int(nullable: false));
            AlterColumn("dbo.AspNetUsers", "Newsletter", c => c.Boolean(nullable: false));
            DropColumn("dbo.AspNetUsers", "Discriminator");
            AddPrimaryKey("dbo.AspNetUserRoles", new[] { "RoleId", "UserId" });
            AddPrimaryKey("dbo.AspNetUserLogins", "UserId");
            RenameColumn(table: "dbo.AspNetUserRoles", name: "RoleId", newName: "IdentityRole_Id");
            RenameColumn(table: "dbo.AspNetUserRoles", name: "UserId", newName: "ApplicationUser_Id");
            RenameColumn(table: "dbo.AspNetUserLogins", name: "UserId", newName: "ApplicationUser_Id");
            RenameColumn(table: "dbo.AspNetUserClaims", name: "UserId", newName: "ApplicationUser_Id");
            AddColumn("dbo.AspNetUserRoles", "RoleId", c => c.String(nullable: false, maxLength: 128));
            AddColumn("dbo.AspNetUserRoles", "UserId", c => c.String(nullable: false, maxLength: 128));
            AddColumn("dbo.AspNetUserLogins", "UserId", c => c.String(nullable: false, maxLength: 128));
            AddColumn("dbo.AspNetUserClaims", "UserId", c => c.String());
            CreateIndex("dbo.AspNetUserRoles", "IdentityRole_Id");
            CreateIndex("dbo.AspNetUserRoles", "ApplicationUser_Id");
            CreateIndex("dbo.AspNetUserLogins", "ApplicationUser_Id");
            CreateIndex("dbo.AspNetUserClaims", "ApplicationUser_Id");
            RenameTable(name: "dbo.AspNetRoles", newName: "IdentityRoles");
            RenameTable(name: "dbo.AspNetUserRoles", newName: "IdentityUserRoles");
            RenameTable(name: "dbo.AspNetUserLogins", newName: "IdentityUserLogins");
            RenameTable(name: "dbo.AspNetUserClaims", newName: "IdentityUserClaims");
            RenameTable(name: "dbo.AspNetUsers", newName: "ApplicationUsers");
        }
    }
}

运行update-数据库时出错：

The object 'PK_dbo.AspNetUserLogins' is dependent on column 'UserId'.
ALTER TABLE DROP COLUMN UserId failed because one or more objects access this column.

Answer 1

我知道你并不期待这样的答案，但我强烈建议不要合并。让IdentityDbContext活它的生活，它也会让你活下去。这只是个骗局。你需要两个单独的数据库，这是额外的费用，比如在Azure，我知道，但是.

1. 如果您尝试在与IdentityDbContext合并的上下文中生活，则需要花费许多小时才能发现它的行为及其EF用法。给自己留点时间吧。
2. 更多:您对标识(用户、角色、登录、锁定等)的API是显式类及其方法，而不是EF。严格地说，您甚至不应该知道身份子系统的持久性(EF + RDBMS)。(把它当作黑匣子)
3. 您对关系的看法是正确的，但是，如果您有一个黑匣子标识子系统，它提供所有服务(包括用户/pwd/profile持久性)，并且希望为使用完全相同用户的业务案例构建关系数据库，那么您的解决方案是什么？只需使用DB中其他子系统提供的用户id即可。不要担心两个系统之间的参照完整性。请考虑以下几点:在经过身份验证的会话中，您的userid将始终有效，否则您在身份验证过程中会遇到严重的问题，因此最需要担心的是.