How to display two class result using LINQ to view in MVC?

kls dngr

11y792.NET

Here is my controller action method code but I don't have any idea to display that result to view?

public class DetailsController : Controller

{

// GET: /Details/

List employees = new List();

List departments = new List();

public ActionResult Index()

{

employees.Add(new Employee { DepartmentID = 1, EmployeeID = 1, EmployeeName = "Kailas" });

employees.Add(new Employee { DepartmentID = 2, EmployeeID = 2, EmployeeName = "Dipak" });

employees.Add(new Employee { DepartmentID = 2, EmployeeID = 3, EmployeeName = "Pramod" });

employees.Add(new Employee { DepartmentID = 1, EmployeeID = 4, EmployeeName = "Prakash" });

employees.Add(new Employee { DepartmentID = 3, EmployeeID = 5, EmployeeName = "Pranav" });

employees.Add(new Employee { DepartmentID = 4, EmployeeID = 6, EmployeeName = "Dipesh" });

departments.Add(new Department { DepartmentID = 1, DepartmentName = "IT" });

departments.Add(new Department { DepartmentID = 1, DepartmentName = "BA" });

departments.Add(new Department { DepartmentID = 1, DepartmentName = "CS" });

departments.Add(new Department { DepartmentID = 1, DepartmentName = "MBA" });

departments.Add(new Department { DepartmentID = 1, DepartmentName = "Comm" });

var list = (from e in employees

join d in departments

on e.DepartmentID equals d.DepartmentID

select new {

EmployeeName = e.EmployeeName,

DepartmentName = d.DepartmentName

}).ToList();

return View(list);

}

3 Replies

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

Amitesh Verma11y ago
use two models instead
kls dngr11y ago
I have query result from two models, so how to display that to view.??

@model IEnumerable

@{
ViewBag.Title = "Index";
}

@Html.ActionLink("Create New", "UserAdd")

@foreach (var item in Model) {

}

@Html.DisplayNameFor(model => model.FirstName)	@Html.DisplayNameFor(model => model.LastName)	@Html.DisplayNameFor(model => model.Address)	@Html.DisplayNameFor(model => model.Email)	@Html.DisplayNameFor(model => model.DOB)	@Html.DisplayNameFor(model => model.Salary)
@Html.DisplayFor(modelItem => item.FirstName)	@Html.DisplayFor(modelItem => item.LastName)	@Html.DisplayFor(modelItem => item.Address)	@Html.DisplayFor(modelItem => item.Email)	@Html.DisplayFor(modelItem => item.DOB)	@Html.DisplayFor(modelItem => item.Salary)	@Html.ActionLink("Edit", "Edit", new { id=item.Id }) \| @Html.ActionLink("Details", "Details", new { id=item.Id }) \| @Html.ActionLink("Delete", "Delete", new { id=item.Id })