BETWEEN AN EQUIVALENT in LINQ

Question

I am looking for the 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?

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

Just use regular comparison operators

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

Answer 3

something like that?

 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 4

In our case, Robert's answer was close to what I was looking for. In our data model, our "end" or "through" date columns are NULL.

The following was necessary:

 Category.Where( w => w.ValidFrom <= now && (w.ValidThru == null ? DateTime.MaxValue : w.ValidThru) >= now).Select(s => s).Dump(); 

Answer 5

I found this to work when you want to compare only part of the data.

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