Showing two tables fields in one view best way

Schleid Alex

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!

4 Replies

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

Jignesh Kumar6y ago
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 Alex6y ago
Yes you right, I forgot to add the reference in address table.
Thank you!
Junaid Musla6y ago
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).
Sachin Singh6y ago
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();
}