Insert Foreign Key

Rijen Juni

I would to insert data from my controller to table customer which have a foreign key from active_customer, no_peserta is the foreign key which refer to active_customer table its my code

var cus = new Customer {
no_peserta =17,
 nama_customer=nama,                                   
no_ktp=noktp,                                   
no_hp=nohp,                                   
tanggal_lahir=tgllahir                               
}; 
context.Customer.Add(cus);
 context.SaveChanges();
but till now its still not work .If you have solution for this please tell me
The error page says " An exception of type 'System.Data.Entity.Infrastructure.DbUpdateException' occurred in EntityFramework.dll but was not handled in user code

Additional information: Unable to update the EntitySet 'Customer' because it has a DefiningQuery and no  element exists in the  element to support the current operation."

2 Replies

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

Upendra Pratap Shahi11y ago
Kindly check your customer table in database that whether this have a primary key or not with auto increment value in that table.

If no any primary key present in your table then add primary key with int datatype and make as auto increment.

After this work , update your entityframework model.

Hope this work for you.
Kindly accept the answer.
0
Manas Mohapatra11y ago
Please check your customer table in database and make sure that it contains a primary key with auto increment value in that table.

If it is not there then add primary key with int datatype and make as auto increment.

Then update your entityframework model.

Hope this will help you to resolve the issue.
0