Insert Foreign Key

Question

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 <InsertFunction> element exists in the <ModificationFunctionMapping> element to support the current operation."

Upendra Pratap Shahi · Answer

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.

Manas Mohapatra · Answer

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.