sql server - MVC Issue: Sign up form, multiple tables -

good day all!

just little background on system, vs2013, sql server 2012 management server.

so i'm still working on mvc project , current i'm stuck issue.

previously have table of employees containing personal information(name, dob, address, etc), , added table containing work related information(eg. job title, date of hire, etc, etc)

i have created 2 models , 2 views user create new employee in single form. need add work info text fields personal info view create page.

i've experimented tuple

 "@model tuple<blah.models.personalinfo, blah.models.workinfo>;" 

and far able generate fields in view ask, how can send information has been entered user table add new employee.

(i.e say, user click "create" , form able encapsulate data entered separate "models" , query database add new guy)

i suggest creating viewmodel instead of passing tuple.

public class employeesviewmodel {     public personalinfo personalinfo { ;set; }     public workinfo workinfo { get; set; } } 

then in controller build viewmodel , pass view.

public  actionresult workaction() {     var personalinfo = new personalinfo();     var workinfo = new workinfo();      var viewmodel = new employeesviewmodel     {         viewmodel.personalinfo = personalinfo,         viewmodel.workinfo = workinfo     };     return view(viewmodel); } 

and in view use following model:

@model employeesviewmodel 

the viewmodel passed controller when save.

as mentioned in stephen muecke's comment can initialize 2 data models based on view model properties.