Showing two tables fields in one view best way

Question

I have two tables, PersonalInformation (PersonID, LastName, FirstName) and Address(Street, City, State, ZipCode). I would like to show these two tables fields in one view "Create" and save the information to the respective table. Note This is a one to one relation where for person there is one address.

Thank you!

Sachin Singh · Answer

This is why we use viewmodels in asp.net MVC visit https://www.sharpencode.com/article/MVC/view-model public class MyViewModel { public PersionalInformation Info { get ; set ;} public Address address{ get ; set ;} } public ActionResult UesrRegistration(){ MyViewModel vm= new MYViewModel(); return view(vm) } public void Save (MyViewModel vm ) { YourContext.PersionalInformations .Add(vm.PersionalInformation); YourContext.SaveChanges(); var Person=YourContext.PersionalInformations.Find(Vm.Id); person.Adresses.Add(vm.address); YourContext.SaveChanges(); }

Jignesh Kumar · Answer

Hi Alex, Please use this link as reference, https://www.c-sharpcorner.com/article/managing-data-with-viewmodel-in-asp-net-mvc/ https://www.tutlane.com/tutorial/aspnet-mvc/how-to-use-viewmodel-in-asp-net-mvc-with-example

Schleid Alex · Answer

Yes you right, I forgot to add the reference in address table. Thank you!

Junaid Musla · Answer

Hi, Your Address table is missing a reference column to PersonalInformation table. Would suggest the schema of Address table as: Address(AddressId,PersonID,Street, City, State, ZipCode).