entity framework without primary key

Asked Mar 26 '14 at 07:13

Active Mar 26 '14 at 07:13

Viewed 944 times

I have created an entity class for my mvc application. But, my table doesn't have a primary key and the VS throws back an error:

"The table/view does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view."

Is there a way to still use the model even if it has no primary key?? or Do I have to add a pk? or should I just use execute command?

Any suggestion/comment is highly appreciated. Thanks in advance. :)

asked Mar 26 '14 at 07:13

user3462803

1

possible duplicate of [Entity Framework: table without primary key](http://stackoverflow.com/questions/3996782/entity-framework-table-without-primary-key) – neel shah Mar 26 '14 at 07:18
I recommend you adding the primary key to the table, there's no pro about not having a PK on table. – Guillermo Oramas R. Mar 26 '14 at 13:16
Thanks for your response. I just added a PK. I can now use my model. :) – user3462803 Mar 27 '14 at 08:21
1

@Guillelon, the question should be more like is the a real need of a PK? Adding a column to a table is not free, it has a cost in terms of space. – Marco Lackovic Dec 14 '14 at 11:08
@Krige in my humble opinion the need is to avoid the process of not having a PK and using EF. – Guillermo Oramas R. Dec 14 '14 at 12:43

0 Answers0