How to access two model records in one model.

See more:

C#

MVC5

Hello,

How to access two model records in one model.

I configured my database and table with entity framework using database schema based approach.

I mean,
table 1 called dept and table 2 called Employee

so, dbcontext creates classes like follow right

public class dept{
public int dept_id{get;set;}
public string dept_name{get;set;}
}

public class Employee{
public int emp_id{get;set;}
public string emp_name{get;set;}
}

Now in the Homecotroller, if i want to use dept records only, i can use using linq query and return to the list
something like follow,

public class DefaultController : Controller
{

WFTOOLSDBContext3 dbcontext = new WFTOOLSDBContext3();
public ActionResult Index()
{
var ivtflist = (from a in dbcontext.depts
select new dept
{
dept_id = a.id,
dept_name= a.dept_name
}).Take(16);
}
}

in view i can put,

@model IEnumerable<dropshiptest.dept> then i can use records using foreach however i need.


But i want to take records the following column from both model (dept as well as employee)
dept_id,
dept_name,
and emp_name

so i tried viewmodel concept follow

step 1: i created another another class called ViewModelDemoVM.cs

ie,

public class ViewModelDemoVM
{
public List<dept> getdept { get; set; }
public List<employee> getemployee { get; set; }

}

setp 2: then in action method of index i tried LINQ query using join follow

var getbothrecord = (from item in dbcontext.depts

join emp in dbcontext.Employee
on item.dept_id equals emp.emp_id
select new ViewModelDemoVM
{
// Here i got stuck , i am getting object of ViewModelDemoVM class, But do not how to do and what to do
//how to access two models records?

}).ToList();

return View(getbothrecord);

how to get two models records in one model and return to the view ?