I have a DropDownList
with which I want to bring the records according to the item
selected, when I click on the search button I get the following error:
The entity or complex type 'DB_ALMACENModel.Product' can not be constructed in a LINQ to Entities query.
This is my code:
public JsonResult BuscarProducto(int tipo)
{
IEnumerable<Producto> productos = (from p in db.Producto
join t in db.Tipo on p.TipoID1 equals t.TipoID
join m in db.Marca on p.MarcaID1 equals m.MarcaID
join o in db.Modelo on p.ModeloID1 equals o.ModeloID
join f in db.Fabricante on p.FabricanteID1 equals f.FabricanteID
where a.TipoID1 == tipo
select new Producto()
{
ProductoID = ProductoID,
TipoID1 = p.TipoID1,
MarcaID1 = p.MarcaID1,
ModeloID1 = p.ModeloID1,
FabricanteID1 = p.FabricanteID1
}).ToList();
var data = productos.Select(p => new
{
Tipo = p.TipoID1
});
return Json(data, JsonRequestBehavior.AllowGet);
}