开发者

EF4 complex type with navigation property (is it possible) or alternatives?

I hit the wall with doing EF4 Model with DB first approach using Linq-to-Entities with POCO...

I have two tables: Customer and NamePrefix that are related via NamePrefixId. Columns are:

Customer             NamePrefix
----------           ----------
CustomerId (PK)      NamePrefixId (PK)
NamePrefixId (FK)
L开发者_JAVA百科astName
FirstName
MiddleInitial
....

In this instance the Customer entity has a navigational property NamePrefix. I created a complex type NameOfPerson, so that I can use it in other entities. The complex type consists of NamePrefixId, LastName, FirstName, MiddleInitial. But now I am getting the following error message on the navigational property to NamePrefix:

Error 111: There is no property with name 'NamePrefixId' defined in type referred by Role 'Customer'.

Is there a way to accomplish this?


This is described directly in Complex type help page. Complex types cannot contain navigation properties.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜