Need solution for this error.

Question

I am getting this error : The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[ f__AnonymousType1`4[System.Int64,System.String,System.String,System.Int16]]', but this dictionary requires a model item of type 'System.Collections.Generic.IEnumerable`1[Projectname.Models.user]'. Here is my code of View @model IEnumerable @{ ViewBag.Title = "Index" ; Layout = "~/Views/Shared/_Layout.cshtml" ; } Index @Html.ActionLink( "Create New" , "Create" ) class = "table" > @Html.Label( "Email" ) @Html.Label( "First Name" ) @Html.Label( "Last Name" ) @Html.Label( "Status" ) @foreach ( var item in Model) { @Html.DisplayFor(modelItem => item.email) @Html.DisplayFor(modelItem => item.first_name) @Html.DisplayFor(modelItem => item.last_name) @Html.DisplayFor(modelItem => item.status) @Html.ActionLink( "Details" , "Details" , new { id = item.id }) | } This is my controller method public ActionResult Index() { var users = (from p in dBModels.users join f in dBModels.auth_assignment.Where(x => x.item_name == "Customer" ) on p.id equals f.user_id select new { id = p.id, first_name = p.first_name, last_name = p.last_name, status = p.status }).ToList(); return View(users); } Kindly give proper answer to resolve this issue asap...

Veerendra Annigere · Answer

public ActionResult Index() { var users = (from p in dBModels.users join f in dBModels.auth_assignment.Where(x => x.item_name == "Customer" ) on p.id equals f.user_id select new { id = p.id, first_name = p.first_name, last_name = p.last_name, status = p.status }).ToList().select(x = > new User() { id = x.id, first_name = x.first_name, last_name = x.last_name, status = x.status }).ToList(); return View(users); }

Samir Bhogayta · Answer

Thanks you very much Veerendra Annigere

Veerendra Annigere · Answer

Check This https://www.c-sharpcorner.com/blogs/error-the-entity-or-complex-type-cannot-be-constructed-in-a-linq-to-entities-query1

Samir Bhogayta · Answer

Hi..Suraj Kumar Please check this code. Still it gives an error List UserList = new List (); UserList = (from p in dBModels.users join f in dBModels.auth_assignment.Where(x => x.item_name == "Customer" ) on p.id equals f.user_id select new { id = p.id, first_name = p.first_name, last_name = p.last_name, status = p.status }).ToList(); return View(UserList);

Suraj Kumar · Answer

You have to change List UserList = new List (); to List UserList = new List ();

Samir Bhogayta · Answer

Hi..Suraj Kumar I tried your code but getting this error. The entity or complex type 'ProjectnameModel.user' cannot be constructed in a LINQ to Entities query.'

Samir Bhogayta · Answer

Hi..Veerendra I tried your code but getting this error. The entity or complex type 'ProjectnameModel.user' cannot be constructed in a LINQ to Entities query.'

Veerendra Annigere · Answer

View expecting List of the User Model. But you're sending the generic Model. public ActionResult Index() { var users = (from p in dBModels.users join f in dBModels.auth_assignment.Where(x => x.item_name == "Customer" ) on p.id equals f.user_id select new User this { id = p.id, first_name = p.first_name, last_name = p.last_name, status = p.status }).ToList(); return View(users); }

Suraj Kumar · Answer

You coluld try this List UserList = new List (); UserList = (from p in dBModels.users join f in dBModels.auth_assignment.Where(x => x.item_name == "Customer" ) on p.id equals f.user_id select new { id = p.id, first_name = p.first_name, last_name = p.last_name, status = p.status }).ToList(); return View(UserList);