dynamic join in linq 0 c#

Question

   var query = from C in db.clients
    join O in db.orders on c.clientid equals O.clientid
    join P in db.products on O.productid equals P.productid
    select new {C,O};

I want to perform a search based on the above join. The input param could be

C.ClientID and/or P.ProductName and/or P.ProductType and/or O.ShippingType

How would i build a dynamic search clause?

Answer 1

Well, there's Dynamic LINQ. Here's a nice intro from Scott Gu. With Dynamic LINQ, you can build your conditionals. For example,

Where("ClientId = 12")