When building a query for the LinkToSql a need to build a where clause that
has both individual values and range selections like this SQL Query:

- WHERE( (IdItem BETWEEN 1 AND 10 OR IdItem = 15 OR IdItem BETWEEN 30 AND
100 OR IdItem = 500... ) AND ( IdMenu BETWEEN 1 AND 5 OR) ...)

How can I write a LINQ statement that makes a efficient query like this?

The range and individual values are created at runtime and stored in memory,
so it is the dynamic buildiing of this staement that are a bit tricky.
Show quoteHide quote

On Oct 18, 10:13 am, Harald SMS <Harald***@discussions.microsoft.com>
wrote:
If you build it up using extension methods directly instead of a query
expression, it's not too bad:

var query = dataContext.WhicheverTable; // The source part

if (restrictByFirstCriterion)
{
    query = query.Where(item => item.Foo > wibble);
}
if (restrictBySecondCriterion)
{
    query = query.Where(item => item.Bar < 0);
}
etc

Basically keep applying Where clauses (or others, such as joins) as
appropriate.

Jon

Exception Handling
Set minimum height on TableRow in FlowDocument (WPF)
PRoblem with System.Windows.Forms.Application.StartupPath when running test project
Passing URI Parameters to WPF App Affecting Deployment
Memory Management