insert record into multiple table using mvc

chandu sahu

8y3.2k.NET

someone please help me to resolve the problem.

i want to insert record on multiple table using database first approach using mvc5

description :

i have two table like student -st_id ,st_name

and class-class_id ,st_id and class_name

3 Replies

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

Ramesh Palanivel8y ago
Accepted answer
Hi Chandu,

Please share your requirement clearly, when you want to insert values in multiple tables?

While doing Student table insert opertiion or class table insert operation?
Nilesh Shah8y ago
also see this:
http://www.c-sharpcorner.com/UploadFile/219d4d/working-with-multiple-tables-in-mvc-using-entity-framework/
Nilesh Shah8y ago
you have two simple options:

1. use SP, in SP write code to insert in these two tables one by one, use transaction is SP if you prefer

2. If possible, use trigger on one table to insert data in another

If you still prefer to do in EF only, then if you have a relation between those two tables, then while inserting one you can specify other as child, and simply insert.

e.g. something like
NorthwindEntities NWEntities = new NorthwindEntities();

foreach (int price in prices)
{
   Product newProduct = new Product();
   newProduct.Price = price;
   NWEntities.Products.AddObject(newProduct);
}

NWEntities.SaveChanges();