Dynamic List in Entity FrameWork WebApi 2.0

Question

Im using DTO's in EntityFrameWork with WebApi 2.0 , so I want to retrieve all the Orders, within the Orders, OrderProducts is a list in my program, I want to retrieve all the OrderProducts related to that Order my code right now is the following:

public async Task < IHttpActionResult > GetOrder() {
    var order = from x in db.Order
    select new OrderDTO {
        OrderId = x.OrderId,
        UserId = x.UserId,
        orderStatusCode = x.orderStatusCode,
        OrderProducts = new List < OrderProductDTO > {
            new OrderProductDTO {
                OrderId = x.OrderProducts.Select(y = >y.OrderId).FirstOrDefault(),
                OrderProductId = x.OrderProducts.Select(y = >y.OrderProductId).FirstOrDefault(),
                ProductId = x.OrderProducts.Select(y = >y.ProductId).FirstOrDefault(),
                Product = new ProductDTO() {
                    productDesc = x.OrderProducts.Select(y = >y.Product.productDesc).FirstOrDefault(),
                    ProductId = x.OrderProducts.Select(y = >y.Product.ProductId).FirstOrDefault(),
                    productName = x.OrderProducts.Select(y = >y.Product.productName).FirstOrDefault(),
                    productPrice = x.OrderProducts.Select(y = >y.Product.productPrice).FirstOrDefault(),
                }
            }
        },
        purchaseDate = x.purchaseDate,
        quantityOrder = x.quantityOrder,
        totalOrderPrice = x.totalOrderPrice,
        User = new UserDTO {
            UserId = x.UserId,
            username = x.User.username,
            userInfo = new UserInfoDTO {
                adress = x.User.UserInfo.adress,
                city = x.User.UserInfo.city,
                country = x.User.UserInfo.country,
                zip = x.User.UserInfo.zip
            }
        }
    };
    return Ok(order);

Everything appears to be ok, but when I call the WebApi only the first element is returned, not all the elements in OrderProduct:

Any idea how to retrieve all the OrderProducts? Thanks.

DavidG · Accepted Answer · 2017-03-07 18:44:31Z

1

Well you're only populating a single item in your query. Instead, you should do this:

....
OrderProducts = x.OrderProducts.Select(op => new OrderProductDTO
{
    OrderId = op.OrderId,
    OrderProductId = op.OrderProductId,
    //etc
}
....

answered Mar 7, 2017 at 18:44

DavidG

120k13 gold badges232 silver badges239 bronze badges

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

2 Comments

Angel Silva Over a year ago

I have another Question: why VS gives me this error: Cannot implicitly convert type 'System.Collections.Generic.IEnumerable<LoginRegister.Models.DTO.OrderProductDTO>' to 'System.Collections.Generic.ICollection<LoginRegister.Models.DTO.OrderProductDTO>'. An explicit conversion exists (are you missing a cast?) but if a append at the end .toList() no problems:

Angel Silva Over a year ago

Thank you very much

Jon S · Accepted Answer · 2017-03-07 18:45:35Z

0

It looks like you're only asking for one Product instead of a List

Product = new ProductDTO() {
                productDesc = x.OrderProducts.Select(y = >y.Product.productDesc).FirstOrDefault(),
                ProductId = x.OrderProducts.Select(y = >y.Product.ProductId).FirstOrDefault(),
                productName = x.OrderProducts.Select(y = >y.Product.productName).FirstOrDefault(),
                productPrice = x.OrderProducts.Select(y = >y.Product.productPrice).FirstOrDefault(),
            }

Should probably be

Products = new List<ProductDTO>() {...}

answered Mar 7, 2017 at 18:45

Jon S

1689 bronze badges

Collectives™ on Stack Overflow

Dynamic List in Entity FrameWork WebApi 2.0

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related