Working with table with no primary key in Entity Framework

Question

Hi All,

I have some tables in the database with no primary key and i want to use these tables in my model but the problem is entity framework consider all non-nullable columns as primary key and thus don't allow me to insert, update or delete data from those tables. Is there any way to get rid of this behavior without making primary key in my database...? Thanx

Answer 1

Hi Raza;

The simple answer is no.

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".

Answer 2

Thanx Fernando for you quick reply.

But what should I do if it is nearly impossible to make the primary key in table because it contains some data that conflict with primary key constrain or any other reason...!!

SO such type of system which have 7 or 8 years huuugggeeee data and many tables don't allow to make primary key cant use Entity Framework or other ORM..?

 

Answer 3

Raza,

One workaround could perhaps be to create a new identity column and make that the primary key.

Answer 4

Hi Raza;

Doing what Bob suggest is about the only way to CRUD operations in Entity Framework.

 

---

Fernando (MCSD)

If a post answers your question, please click "Mark As Answer" on that post and "Mark as Helpful".