insert record into multiple table using mvc

Question

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

Ramesh Palanivel · 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 Shah · Answer

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();

Nilesh Shah · Answer

also see this: http://www.c-sharpcorner.com/UploadFile/219d4d/working-with-multiple-tables-in-mvc-using-entity-framework/

insert record into multiple table using mvc

Answers (3)