我创建了一个订单实体,现在我有一个 Money 类型,我想将其作为自己的类型包含在我的订单实体中。
public class Money
{
public decimal Value { get; set; }
public Currency Currency { get; set; }
}
我的Order类如下所示:
public class Order
{
[Key]
public long OrderId { get; set; }
}
现在我想给订单实体添加一个类似以下的货币类型:
public class Order
{
[Key]
public long OrderId { get; set; }
public Money Amount { get; set; }
}
订单上下文(OrderContext)如下所示:
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<Order>().OwnsOne(o => o.Amount);
}
当我运行实体框架迁移时遇到了问题。 迁移完成后,我得到了以下结果:
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.AlterColumn<long>(
name: "OrderId",
table: "Order",
nullable: false,
oldClrType: typeof(long),
oldType: "bigint")
.OldAnnotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn);
migrationBuilder.AddColumn<int>(
name: "Amount_Currency",
table: "Order",
nullable: true);
migrationBuilder.AddColumn<decimal>(
name: "Amount_Value",
table: "Order",
nullable: true);
}
正如您所看到的,由于某种原因,使用OwnOne会改变我的OrderId列,并且在我检查生成的SQL时,它似乎将其IDENTITY删除了。
BEGIN
IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20200311224448_1.0.108-g5d3eec73db-Order') THEN
ALTER TABLE `Order` ALTER COLUMN "OrderId" TYPE bigint;
ALTER TABLE `Order` ALTER COLUMN "OrderId" SET NOT NULL;
ALTER TABLE `Order` ALTER COLUMN "OrderId" DROP IDENTITY;
ALTER TABLE `Order` ALTER COLUMN "OrderId" DROP DEFAULT;
END IF;
END $$;
DO $$
BEGIN
IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20200311224448_1.0.108-g5d3eec73db-Order') THEN
ALTER TABLE `Order` ADD "Amount_Currency" integer NULL;
END IF;
END $$;
DO $$
BEGIN
IF NOT EXISTS(SELECT 1 FROM "__EFMigrationsHistory" WHERE "MigrationId" = '20200311224448_1.0.108-g5d3eec73db-Order') THEN
ALTER TABLE `Order` ADD "Amount_Value" numeric NULL;
END IF;
END $$;
请问有人知道为什么在Entity Framework和PostgreSQL数据库中添加一个Owned type会导致这种行为,我该如何确保键字段不会被更改?
- PostgreSQL 11.7
- Microsoft.AspNetCore.App 3.1.2
- Microsoft.NETCore.App 3.1.2
- Microsoft.EntityFrameworkCore.Design Version=3.1.1
- Npgsql.EntityFrameworkCore.PostgreSQL Version=3.1.2