慕盖茨1488219
除了@ckal建议什么,这是至关重要的给每个重命名Configuration.cs自己的命名空间。如果您不这样做,EF将尝试将迁移应用于错误的上下文。以下是适合我的特定步骤。如果迁移搞砸了,而您想创建一个新的“基准”:删除Migrations文件夹中的所有现有.cs文件在SSMS中,删除__MigrationHistory系统表。创建初始迁移:在程序包管理器控制台中:Enable-Migrations -EnableAutomaticMigrations -ContextTypeNameNamespaceOfContext.ContextA -ProjectName ProjectContextIsInIfNotMainOne-StartupProjectName NameOfMainProject -ConnectionStringName ContextA在解决方案资源管理器中:将Migrations.Configuration.cs重命名为Migrations.ConfigurationA.cs。如果使用Visual Studio,这应该自动重命名构造函数。确保确实如此。编辑ConfigurationA.cs:将名称空间更改为NamespaceOfContext.Migrations.MigrationsAEnable-Migrations -EnableAutomaticMigrations -ContextTypeNameNamespaceOfContext.ContextB -ProjectName ProjectContextIsInIfNotMainOne-StartupProjectName NameOfMainProject -ConnectionStringName ContextB在解决方案资源管理器中:将Migrations.Configuration.cs重命名为Migrations.ConfigurationB.cs。再次,确保构造函数也已正确重命名。编辑ConfigurationB.cs:将名称空间更改为NamespaceOfContext.Migrations.MigrationsBadd-migration InitialBSchema -IgnoreChanges -ConfigurationTypeNameConfigurationB -ProjectName ProjectContextIsInIfNotMainOne-StartupProjectName NameOfMainProject -ConnectionStringName ContextB Update-Database -ConfigurationTypeName ConfigurationB -ProjectNameProjectContextIsInIfNotMainOne -StartupProjectName NameOfMainProject-ConnectionStringName ContextBadd-migration InitialSurveySchema -IgnoreChanges -ConfigurationTypeNameConfigurationA -ProjectName ProjectContextIsInIfNotMainOne -StartupProjectNameNameOfMainProject -ConnectionStringName ContextA Update-Database -ConfigurationTypeName ConfigurationA -ProjectNameProjectContextIsInIfNotMainOne -StartupProjectName NameOfMainProject-ConnectionStringName ContextA在Package Manager控制台中创建迁移脚本的步骤:运行命令Add-Migration MYMIGRATION -ConfigurationTypeName ConfigurationA -ProjectNameProjectContextIsInIfNotMainOne -StartupProjectName NameOfMainProject-ConnectionStringName ContextA要么 -Add-Migration MYMIGRATION -ConfigurationTypeName ConfigurationB -ProjectNameProjectContextIsInIfNotMainOne -StartupProjectName NameOfMainProject-ConnectionStringName ContextB可以重新运行此命令,直到对数据库应用更改为止。针对所需的本地数据库运行脚本,或者运行不带-Script的Update-Database以在本地应用:Update-Database -ConfigurationTypeName ConfigurationA -ProjectNameProjectContextIsInIfNotMainOne -StartupProjectName NameOfMainProject-ConnectionStringName ContextA要么 -Update-Database -ConfigurationTypeName ConfigurationB -ProjectNameProjectContextIsInIfNotMainOne -StartupProjectName NameOfMainProject-ConnectionStringName ContextB