How to save data in multiple tables from single view

suman goud

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

4 Replies

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

Rajendra Mote10y ago
use forecach loop and chane your table instance with every iteration and perform insert operation.
Vinay Singh10y ago
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 Punhani10y ago
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 Srivastava10y ago
Hi Suman,
Visit here you can find proper example.
http://www.codeproject.com/Tips/651495/Inserting-Data-into-Multiple-Tables-using-Code-Fir