BETWEEN EQUIVALENT in LINQ

Question

Hi:

I am looking LINQ equivalent for the following query

Select * from ct_rate
WHERE
'2010-10-01 00:00:00'
BETWEEN start_date and end_date;

ANY IDEA?

Thanks in Advance

Answer 1

You need to use two comparison operations:

DateTime date = new DateTime(2010, 10, 1);

var results = from rate in ct_rates
              where rate.StartDate <= date && rate.EndDate >= date
              select rate;

Answer 2

something like this?

var result = from context.ct_rate.Where(d => d.start_date >= "2010-10-01 00:00:00" && d.end_date <= "2010-10-01 00:00:00")

Answer 3

Just use ordinary comparison operators

var result = ct_rate
    .Where(x => x.start_date <= myDate && x => x.endDate >= myDate);