Loading

How to use entity framework with table that not have primary

ahmed elbarbary

Problem

How to use entity framework with database tables that not have primary key.

i have old database made by SQL server 2012 i get requirement to work as entity

framework technique and mvc vs2017 .

I found that more tables not have primary keys

and no relation ship between some tables for each other

so that how to solve that problem .

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sanwar Ranwa7y ago
Hello Ahmed

If there's no primary key, Entity Framework can't use the table. EF MUST have a way to uniquely identify every record in the table, and that means having primary keys.

Check this Link carefully

https://stackoverflow.com/questions/15381233/can-we-have-table-without-primary-key-in-entity-framework
+1