How to extract SQL BETWEEN command in Entity Framework

Question

As the name says, I want something like:

SELECT * FROM TABLE WHERE YEAR BETWEEN 2011 AND 2005;

Any help here?

+5

Felixmm Apr 15 '12 at 12:58

2 answers

I don't know about a command BETWEENin sql, but you can always do something like

where year >= 2005 AND year <= 2011

+1

ControlAltDel Apr 15 '12 at 13:02

Arion · Accepted Answer · 2012-04-15T13:01:08+0000

There is no syntax in linq BETWEEN. Therefore, you may have to use something like this:

var result=(
   from t in db.TABLE
   where t.YEAR>=2005 && t.YEAR=<2011
   select t 
);

Where db is the linq data context