My actions
public ActionResult Orders()
{
NorthwindEntities db = new NorthwindEntities();
return View(db.Orders.ToList());
}
public ActionResult OrderDetails(int id)
{
NorthwindEntities db = new NorthwindEntities();
var query = from od in db.Order_Details
join p in db.Products
on od.ProductID equals p.ProductID
where od.OrderID == id
select new
{
od.OrderID,
od.ProductID,
p.ProductName,
od.Quantity,
od.UnitPrice,
od.Discount,
};
return View(query.ToList());
}
My view
@model List MvcApplication2.Models.Order_Detail
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<title>OrderDetails</title>
</head>
<body>
@{
foreach (var item in Model)
{
@Html.DisplayFor(x => item.OrderID)
@Html.DisplayFor(y => item.ProductID)
@Html.DisplayFor(y => item.Product.ProductName);
@Html.DisplayFor(z => item.Quantity)
@Html.DisplayFor(z => item.UnitPrice)
@Html.DisplayFor(z => item.Discount)
}
}
</body>
</html>
and my error
The model item passed into the dictionary is of type 'System.Collections.Generic.List`1[<>f__AnonymousType0`5[System.Int32,System.Int32,System.Int16,System.Decimal,System.Single]]', but this dictionary requires a model item of type 'System.Collections.Generic.List`1[MvcApplication2.Models.Order_Detail]'.