CODEWITHSUNDEEP
asp.net-mvcsubsonicsubsonic3
davethecoder
davethecoder

Reputation: 3932

subsonic 3.0.0.3 activeRecord Between

Hi im using subsonic 3.0.0.3 activeRecord but cant seems to figure between !

select * from orders where orderdate between startdate, enddate;

have tried IQueryable<orders> myOrders = order.All().Where(x => x.order_date).isBetweenAnd

help much appreciated, please make note of version number, and that any answers actually work for that version and activeRecord.

thanks

Upvotes: 0

Views: 84

Answers (1)

TheVillageIdiot
TheVillageIdiot

Reputation: 40537

try:

order.All().Where(x => x.order_date >= Min_Date && x.order_date <= Max_Date);

Upvotes: 2

Related Questions