CODEWITHSUNDEEP
entity-frameworkvisual-studio-2010.net-4.0
Shimmy Weitzhandler
Shimmy Weitzhandler

Reputation: 104771

Create One-To-One relationship between table and view in EF4?

I have a table Item (ItemId int PK, Title vc, Description vc)

I created a testing view called ItemView: SELECT * FROM Item.

I added this view to my model, removed all the keys but the real key, added a 1-1 association, and mapped it, but I get 2 errors:

  1. The table/view 'dbo.ItemView' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
  2. Error 3021: Problem in mapping fragments starting at line xxxx: Each of the following columns in table Item is mapped to multiple conceptual side properties: Item.ItemId is mapped to What can be the problem?

Upvotes: 1

Views: 623

Answers (1)

Shimmy Weitzhandler
Shimmy Weitzhandler

Reputation: 104771

Edmx Views Processor - a hotfix for this issue.

Upvotes: 1

Related Questions