sql-server - Entity Framework 6 数据库首先不会在具有复合键的表上生成实体

Question

假设我有以下带有复合主键的表定义:

create table [dbo].[CustomerRequests] (
    [CustomerId] int not null,
    [RequestId] int not null,
    constraint [PK_CustomerRequests] primary key clustered ([CustomerId] asc, [RequestId] asc),
    constraint [FK_CustomerRequests_Customers] foreign key ([CustomerId]) references [dbo].[Customers] ([CustomerId]),
    constraint [FK_CustomerRequests_Requests] foreign key ([RequestId]) references [dbo].[Requests] ([RequestId])
);

当我更新模型以包含此表时， Entity Framework 无法生成实体类。这是由于复合主键吗？有没有办法让Entity Framework生成实体类？

Answer 1

Gert Arnold 的评论为我指明了正确的方向，this answer 也是如此。 .

一旦我在两个主键之外添加了另一列， Entity Framework 就生成了实体。以下是 EF Database First 将为其创建实体的示例表定义:

create table [dbo].[CustomerRequests] (
    [CustomerId] int not null,
    [RequestId] int not null,
    [TimestampUtc] datetime not null,
    constraint [PK_CustomerRequests] primary key clustered ([CustomerId] asc, [RequestId] asc),
    constraint [FK_CustomerRequests_Customers] foreign key ([CustomerId]) references [dbo].[Customers] ([CustomerId]),
    constraint [FK_CustomerRequests_Requests] foreign key ([RequestId]) references [dbo].[Requests] ([RequestId])
);