How to save data in multiple tables from single view

Question

i want to save data of my register form  in 4 different tables when i click save, i have same columns in tables . entity framework   is taking only one table ,when i i update EF to add another tables it is not taking and how to access multiple models in single view

Rajendra Mote · Answer

use forecach loop and chane your table instance with every iteration and perform insert operation.

Vinay Singh · Answer

Create an SP. in this SP create insert statement for all four table. and while saving the data pass all records to SP and manage the data in SP inself. have a look how to use SP in Entity framework http://stackoverflow.com/questions/13981523/executing-a-update-insert-stored-procedure-with-entity-framework-4-1 http://www.aspdotnet-pools.com/2014/08/insert-update-delete-operation-in.html https://www.mindstick.com/Articles/1110/select-insert-update-and-delete-using-stored-procedure-in-asp-dot-net-mvc4

Rajeev Punhani · Answer

Hi Suman, Regarding access of multiple models in a single viewyou can use view model. Many ways are there to do but I prefer view model.Using view model you can have multiple tablesand you can pass a view model to controller and add to different tables.Please find the below link. http://www.c-sharpcorner.com/UploadFile/ff2f08/multiple-models-in-single-view-in-mvc/ If the above solution is helpful then, accept the answer.

Bikesh Srivastava · Answer

Hi Suman, Visit here you can find proper example. http://www.codeproject.com/Tips/651495/Inserting-Data-into-Multiple-Tables-using-Code-Fir

How to save data in multiple tables from single view

Answers (4)