c# - Compare dd-mm-yyyy datetime

Question

Problem

I want to compare "dd-mm-yyyy" DateTime's without factoring in the time.

Attempt

I have tried comparing the standard DateTime values with my database DateTime's like this:

C#/LINQ:

 var startDate = DateTime.Today.AddDays(-10);
 var endDate = DateTime.Today;     
     dateList= (from x in db.MY_DB
         where (x.DATE >= startDate && x.DATE < endDate)   
         select x).ToList();

However, my list never gets populated, even though many entries meet this criteria, which I verified with the following query in SQL:

SQL Query:

Select * from db.my_db where date between '13-JUN-2016' and '23-JUN-2016';

Answer 1

Use DbFunctions.TruncateTime or EntityFunctions.TruncateTime based on your Entity Framework version which:

When used as part of a LINQ to Entities query, this method invokes the canonical TruncateTime EDM function to return the given date with the time portion cleared.

var start = DateTime.Now.Date.AddDays(-10);
dateList = (from x in db.MY_DB
    where ((DbFunctions.TruncateTime(x.DATE) < DateTime.Now.Date) &&
    ((DbFunctions.TruncateTime(x.DATE) >= start)
    select x).ToList();