views:

58

answers:

0

Hi, there is any way to order a query by a many-to-many relation table column in linq? and in scottgu's DynamicLinq?

For example:

Products: p_id, p_name

Product_Order: p_id, o_id, quantity

Order: o_id, o_name

how can I query for order by Product_Order quantity?

from p in model.Products order by p.Product_Order.quantity select p