Use Linq in a C# Web API

Question

Hi I'm development a Web API in C# with entity framework, I have 4 tables in my database

Products: 
    IdProduct, 
    IdCategory, 
    IdBrand, 
    Product, 
    Price, 
    Descryption, 
    IdOffice

Category: 
    IdCategory, 
    Category

Brand: 
    IdBrand, 
    Brand

Office: 
    IdOffice, 
    Office

And I did a Web API with the Products model but I want to show the data and not the Id.

This is what I have done but gives me an error in the return

Cannot implicitly convert type 'System.Linq.IQueryable' anonymous type int IdProducto, string Category, string Product, string Brand, string office, string Description, decimal? Price' in System.Linq.IQueryable NameProject

private ExamenPOO1Entities db = new ExamenPOO1Entities();
private ExamenPOO1Entities1 ca = new ExamenPOO1Entities1();
private ExamenPOO1Entities2 ma = new ExamenPOO1Entities2();
private ExamenPOO1Entities3 su = new ExamenPOO1Entities3();

// GET: api/Productoes
public IQueryable<Producto> GetProductos()
{
    var query =
        from p in db.Productos
        join c in ca.Categorias
        on p.IdCategoria equals c.IdCategoria
        join m in ma.Marcas 
        on p.IdMarca equals m.IdMarca
        join s in su.Sucursales
        on p.IdSucursal equals s.IdSucursal
        select new 
        { IdProducto =p.IdProducto, Categoria = c.Categoria1, Producto = p.Producto1,
            Marca = m.Marca1, Sucursal = s.Sucursal, Descripcion = p.Descripcion,
            Precio = p.Precio};
        return query;
}

Unrelated, but ouch about 4 db contexts - this means joins are done in memory. Are you sure you cant reduce these? — StuartLC
– StuartLC, Commented Jun 1, 2018 at 14:50
Ugh, joining across contexts is nasty for sure. Maybe it's that giving you the errors? We don't know unless you tell us what you error is... — DavidG
– DavidG, Commented Jun 1, 2018 at 14:51
Cannot implicitly convert type 'System.Linq.IQueryable' <<anonymous type int IdProducto, string Category, string Product, string Brand, string office, string Description, decimal? Price>>' in System.Linq.IQueryable <NameProject> — Eduardo Noyola
– Eduardo Noyola, Commented Jun 1, 2018 at 15:03

johnny 5 · Accepted Answer · 2018-06-01 15:58:28Z

2

You are having this error because as you specified, your method must return a IQueryable<Producto> but instead you're returning an anonymous object when you use the code below

select new {
     IdProducto =p.IdProducto, 
     Categoria = c.Categoria1, 
     Producto = p.Producto1,
     Marca = m.Marca1, 
     Sucursal = s.Sucursal, 
     Descripcion = p.Descripcion,
     Precio = p.Precio
}

So in order to be consistent with the method's signature the select should create a new Producto

select new Producto
    { ... }

edited Jun 1, 2018 at 15:58

johnny 5

21.2k55 gold badges138 silver badges217 bronze badges

answered Jun 1, 2018 at 15:15

othman.Da

6414 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Christoph Over a year ago

But that won't be work either, at least not how the classes are defined right now. For example, the new object received a property Category/Categoria. The Product/Producto class does not have such a property. You may just want to return an IQueryable<object>.

Eduardo Noyola Over a year ago

So should do only 1 model with all my tables?

othman.Da Over a year ago

It'll work if you respect the 'Producto' properties and not putting all the things between curly braces, if you want all the data specified in your first select you should whether create a model with these props or return a IQueriable<object> and it'll work (Don't forget to change the signature in this case from IQueriable<Producto> to IQueriable<object>).

Collectives™ on Stack Overflow

Use Linq in a C# Web API

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related