C# EF: How to search between two dates in EF but want to exclude time from data

Question

i do not know how to execlude time from data when doing comparison in EF.

    using (var db = new DbContext())
    {
        var query = from n in db.BDatas
                    orderby n.AddDate,n.CountryCode
                    where n.CountryCode=="GB" 
                    && (n.AddDate >= stdate.Date && n.AddDate <= etdate)
                    select n;
    }

i guess my above query will include date and time when comparision will occur. so tell me what to do?

Answer 1

You don't need to exclude time from SQL comparison. You can just exclude time from parameters which you are passing:

using (var db = new DbContext())
{
    var startDate = stdate.Date; 
    var endDate = etDate.Date.AddDays(1);

    var query = from n in db.BDatas
                orderby n.AddDate,n.CountryCode
                where n.CountryCode=="GB" 
                && (n.AddDate >= startDate && n.AddDate < endDate)
                select n;
}

Note that I used < endDate and added one more day to it. Thus you will have results from any time of previous day.