Dynamic Where in Linq to SQL

Question

How would I get something like this to work so that I can dynamically alter the where-clause in this linq to sql query?

Dim AccountID = 1234

Dim AccountList

Select Case Types
    Case 1
        AccountList = (from a in dc.Accounts where a.ID = AccountID)
    Case 2
        AccountList = (from a in dc.Accounts where a.ID = AccountID And a.ParentID = AccountID)
    Case Else
        AccountList = (from a in dc.Accounts)
End Select

Return From p in dc.Products where AccountList.Contains(p.Order.Transaction.AccountID)

With the above code I get this error:

Late binding operations cannot be converted to an expression tree

Jon Skeet · Accepted Answer · 2010-09-14 17:11:18Z

3

It sounds like you've either not got Option Strict on. Put it on, and specify the type of AccountList as IQueryable(Of Account). Then you won't be using late binding, and all should be well.

answered Sep 14, 2010 at 17:11

Jon Skeet

1.5m893 gold badges9.3k silver badges9.3k bronze badges

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

1 Comment

RichC Over a year ago

The AccountList is just a list of strings actually so making it IQueryable(of String) did the trick - thanks!

Collectives™ on Stack Overflow

Dynamic Where in Linq to SQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related