Entity framework primary keys in Views

Question

I have to use a View with the EF but, when I import it, the primary key of the view is displayed incorrectly and for some reason I can't change it.

possible duplicate of [Entity Framework and Sql Server view question](http://stackoverflow.com/questions/1013333/entity-framework-and-sql-server-view-question) — Michael Maddox, Sep 15 '11 at 14:42

score 7 · Answer 1 · edited May 23 '17 at 11:48

7

Appears to be a known issue - see this other StackOverflow question and its answers:

Entity Framework and SQL Server View

Marc

edited May 23 '17 at 11:48

Community

1
1

answered Jun 19 '09 at 20:28

marc_s

732,580
175
1,330
1,459

score 3 · Answer 2 · edited Apr 08 '12 at 11:26

3

I had a similar problem when i wanted to do a group by in a view that was not easy in linq but ended up not working. What worked for me was to specifically change the entity key in Entity Framework designer to a int column that is unique. If it doesnt exist then create a simple incremented int field in your view definition and use that as your key.

edited Apr 08 '12 at 11:26

Sergey Glotov

20,200
11
84
98

answered Apr 08 '12 at 09:55

Mark

31
1

score 0 · Answer 3 · edited Oct 21 '19 at 16:02

0

In my experience the entity keys on a View are defined using the primary keys of the view (from the select clause).

If you have multiple tables in the view, you must select the primary key, not the foreign key, to see it as an entity key.

edited Oct 21 '19 at 16:02

James Skemp

8,018
9
64
107

answered Dec 03 '09 at 11:36

Davide Icardi

11,919
8
56
77

Entity framework primary keys in Views

3 Answers3