Entity Framework: create entity and insert data in table without primary key

Question

There are couple similar questions and answers are like: Better add a primary key...

The question is: Is it possible to insert data in table without primary key using entity framework?

Or I have to use SqlConnection class?

Thank you

Ladislav Mrnka · Accepted Answer · 2012-05-16 13:06:52Z

4

No it is not possible with EF. EF demands that every table has a primary key. If it doesn't have a primary key you must somehow cheat EF so that it believes that some column is primary key - that requires manual modification of EDMX file.

Generally if you have table where no set of columns uniquely identifies records you should not use EF to work with such table because EF always demands unique identification. This is also true for database views.

answered May 16, 2012 at 13:06

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework: create entity and insert data in table without primary key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related