Cannot perform Create, Update or Delete operations on Table(Employee) because it has no primary key

Have you ever seen a scenario where you try to insert the data in table using LINQ to SQL and you get an error saying Can't perform Create, Update or Delete operations on Table(<TableName>) because it has no primary key.

SampleDataContextDataContext db = new SampleDataContextDataContext();

Employee emp = new Employee()

{

FirstName = "Experts",

Lastname = "Comment",

Address = "alpha.beta@gmail.com"

};

db.Employees.InsertOnSubmit(emp);

db.SubmitChanges();

The above code was giving the same error when trying to insert new row.

The reason behind this issue is LINQ does not provide the facility to insert data into Table without primary key. At this point you have two option which you can use to perform the insert operation.

1. Create a store procedure and call the same from LINQ.

SampleDataContextDataContext db = new SampleDataContextDataContext();

db.InsertEmployeeData("Experts","Comment", "alpha.beta@gmail.com");

Here I have created an store procedure with name InsertEmployeeData, and called it from the code. Simple and straight forward.

2. Create a Insert statement and execute using LINQ.

SampleDataContextDataContext db = new SampleDataContextDataContext();

string insertStatement = "Insert into Employee values('Experts', 'Comment','alpha.beta@gmail.com')";

db.ExecuteQuery<Employee>(insertStatement);

Here I created normal insert query and executed using the the LINQ ExecuteQuery.

Add Comment

Comment

Name
(Required)

E-mail (Privacy assured)
(Required)

Subscribe to this site by email

Test Your Skill

Cannot perform Create, Update or Delete operations on Table(Employee) because it has no primary key

Add Comment

Poll of the Day

Related Contents

Online Test Papers

Related Tutorials

Fun @ Work

Top Blogs