"Between" in Linq C#

Question

Possible Duplicate:
LINQ Between Operator

Dear All,
Hi,
I need to write this query in LINQ C#. can anyone help me?

Select *  
From Mytable  
where MyText BETWEEN 'john' AND 'Pear'

Did you tried http://www.google.com/#hl=en&safe=off&q=linq+between&aq=0&aqi=g10&oq=linq+be&fp=c5aa4278f68e4a4 — Fitzchak Yitzchaki, Feb 16 '10 at 08:44

jjnguy · Accepted Answer · 2010-02-16T08:55:53.557

8

I believe this query should work:

var results = yourTable.Where(x => x.Text.CompareTo("john") > 0 && 
                                   x.Text.CompareTo("Pear") < 0);

This assumes that you want to compare the text in each row of the table, and not some pre-dfined string.

edited Feb 16 '10 at 08:55

answered Feb 16 '10 at 08:43

jjnguy

score 3 · Answer 2 · answered Feb 16 '10 at 09:09

Here is how you can do it with ObjectQuery

MytableSet.Where("it.Name between @start and @end", new ObjectParameter("start", "john"), new ObjectParameter("end", "Pear"))

EDIT:

Forget to mention that this statement is specific to Entity Framework not LINQ2SQL.

2 Answers2