我在try 初始化数据库时遇到问题.在我的应用程序中,我有两个DbContext,标识DbContext和Auctionhouse DbContext,它们都使用相同的数据库,但使用不同的模式.当我try 使用Update-Database -Context IdentityDbContext
命令初始化数据库时,我得到以下异常:
System.MissingMethodException: Method not found: 'System.Data.Common.DbParameter System.Data.Common.DbBatchCommand.CreateParameter()'.
at Npgsql.NpgsqlCommand..ctor(String cmdText, NpgsqlConnection connection)
at Npgsql.NpgsqlCommand.CreateCachedCommand(NpgsqlConnection connection)
at Npgsql.NpgsqlConnection.CreateCommand()
at Npgsql.NpgsqlConnection.CreateDbCommand()
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.CreateDbCommand(RelationalCommandParameterObject parameterObject, Guid commandId, DbCommandMethod commandMethod)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlDatabaseCreator.Create()
at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
at Microsoft.EntityFrameworkCore.Design.Internal.MigrationsOperations.UpdateDatabase(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabaseImpl(String targetMigration, String connectionString, String contextType)
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.UpdateDatabase.<>c__DisplayClass0_0.<.ctor>b__0()
at Microsoft.EntityFrameworkCore.Design.OperationExecutor.OperationBase.Execute(Action action)
Method not found: 'System.Data.Common.DbParameter System.Data.Common.DbBatchCommand.CreateParameter()'.
以下是涉及的组件的相关代码:
public class IdentityDbContext
: IdentityDbContext<ApplicationUser, IdentityRole<Guid>, Guid>
{
public const string Schema = "identity";
public IdentityDbContext(
DbContextOptions<IdentityDbContext> options)
: base(options) { }
protected override void OnModelCreating(
ModelBuilder modelBuilder)
{
modelBuilder.HasDefaultSchema(Schema);
base.OnModelCreating(modelBuilder);
}
}
配置DbContext的ServiceCollectionExtensions.cs
文件如下所示:
var connectionString = configuration.GetConnectionString("IdentityConnection");
services.AddDbContext<IdentityDbContext>(options =>
{
options.UseNpgsql(connectionString, options =>
{
options.MigrationsHistoryTable(
tableName: HistoryRepository.DefaultTableName,
schema: IdentityDbContext.Schema);
});
});
如能就如何在创建迁移期间解决此问题提供任何帮助或指导,将不胜感激.谢谢!
Directory.Packages.props
文件如下所示:
<Project>
<PropertyGroup>
<ManagePackageVersionsCentrally>true</ManagePackageVersionsCentrally>
</PropertyGroup>
<ItemGroup>
<PackageVersion Include="Microsoft.AspNetCore.OpenApi" Version="8.0.0-rc.2.23480.2" />
<PackageVersion Include="Microsoft.EntityFrameworkCore.Tools" Version="8.0.0-rc.2.23480.1" />
<PackageVersion Include="NSwag.AspNetCore" Version="13.20.0" />
<PackageVersion Include="NSwag.MSBuild" Version="13.20.0" />
<PackageVersion Include="MediatR" Version="12.1.1" />
<PackageVersion Include="Microsoft.AspNetCore.Identity.EntityFrameworkCore" Version="8.0.0-rc.2.23480.2" />
<PackageVersion Include="Microsoft.AspNetCore.Identity.UI" Version="8.0.0-rc.2.23480.2" />
<PackageVersion Include="Npgsql.EntityFrameworkCore.PostgreSQL" Version="8.0.0-rc.2" />
</ItemGroup>
</Project>
这Directory.Build.props
人看起来是这样的:
<Project>
<PropertyGroup>
<TargetFramework>net8.0</TargetFramework>
<TreatWarningsAsErrors>true</TreatWarningsAsErrors>
<ImplicitUsings>enable</ImplicitUsings>
<Nullable>enable</Nullable>
</PropertyGroup>
</Project>
我还找不到任何不匹配的地方.除了NSWAG,我已经安装了每个包的所有最新预发行版.