Error in Linq query

1

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);
    }
    
asked by Leo 18.07.2018 в 06:10
source

0 answers