.net 3.5 Linq queries does not seem to support date comparison. For example following code did not support.

entities.Object.Where(p => p.ToDateTime.Date>=DateTime.Now.Date
&& p.FromDateTime.Date<= DateTime.Now.Date)

But it supported comparison of date time.

entities.Object.Where(p => p.ToDateTime>=DateTime.Now
&& p.FromDateTime<= DateTime.Now)

Finally found a solution to compare the Date only trough linq query

entities.Object.Where(p => p.ToDateTime>=DateTime.Today
&& p.FromDateTime<= DateTime.Today)

Note:In my case the date object stored in the database recorded 00:00 as its time. In C# with the  DateTime.Today it sets the time to 12:00AM which is 00:00 in SQL.

This worked for me. Hope it’s helpful to you as well

Advertisements