Passing list of Objects from Controller to View

I am trying to pass a list of Objects from controller to View ,where the attributes of the objects are retrieved from database using LINQ. The MODEL Code is given below:

public class Department

{

[Key]

public int DepartmentId { get; set; }

[Required(ErrorMessage = "Enter Department Name")]

[DisplayName("Department Name")]

public string DepartmentName { get; set; }

}

The Controller Code is :

public ActionResult ShowDepartments()

{

var departmentList = db.Deapartment.Select(x => new

{

x.DepartmentId,

x.DepartmentName

}).ToList();

return View(departmentList);

}

And the View Code is:

@model List

ViewBag.Title = "ShowDepartments";

Layout = "~/Views/Shared/_Layout.cshtml";

}

Show Departments

@foreach (var department in Model)

{

}

@department.DepartmentId

@department.DepartmentName

}

But when I run the project, it shows the following exception:

Exception Details: System.InvalidOperationException: The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[<>f__AnonymousType3`2[System.Int32,System.String]]', but this dictionary requires a model item of type 'System.Collections.Generic.List`1[PractiseMVC11_17_2017.Models.Department]'.

1 Reply

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

Nilesh Shah8y ago
that is because you are directly selecting list of objects from DB query in your controller, and passing that to view.

return View(departmentList);

here you are passing departmentList which is derived from db.Deapartment, while your view expects:
@model List

solution is to create list of Models.Department in controller, assign it values from db.Deapartment, then pass list of Models.Department to view