mardi 4 août 2015

Select data from 3 tables with Linq to SQL

I have 3 tables. Orders, OrderItems and OrderItemServices. Each order can contain multiple OrderItems and each OrderItem can contain multiple OrderItemServices. I want to get a list of data of all orders from these tables in Linq. I could write a join but how do I make an anonymous data type to in select clasue which can give me Order list in this hierarchy?

If I use navigation properties and then select OrderItemServices in side select clause shown below it would fire individual select query for each OrderItemService which I want to avoid.

from order in Orders
select new
{
    ActiveOrders = order,
    ActiveOrderItems =order.OrderItems,
    ActiveServices = order.OrderItems.Select(o => o.OrderItemServices)
}

Is it possible to group each order with a structure of multiple items inside it and multiple services inside items?



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire