Tuesday, November 03, 2009
This example uses PredicateBuilder by Albahari & Albahari - http://www.albahari.com/nutshell/predicatebuilder.aspx

If you need to return rows based on values of child items for the row, then the following example might come in useful:

            predicate = predicate.And(p => 
                p.OrderBasketItems.Where(obi => obi.CustomerId > 0).Count() > 0);
This will generate a sub-query such as:

SELECT [t0].[ColumnX], [t0].[ColumnA]
FROM [dbo].[Order] AS [t0]
WHERE ([t0].[OrderStatusID] = 4) AND (((
    SELECT COUNT(*)
    FROM [dbo].[OrderItems] AS [t1]
    WHERE ([t1].[CustomerId] > 0) AND ([t1].[OrderId] = [t0].[OrderID])
    )) > 0) 

Tuesday, November 03, 2009 3:49:48 PM (GMT Standard Time, UTC+00:00) | Comments [0] | LINQ#
Search
Archive
Links
Categories
Admin Login
Sign In
Blogroll