See Date only, in a Datetime field with LINQ

Question

I’m generating a report in an app that I’m developing, but I have a little problem. When sending a query in a date interval, I can’t get anything, because it is a DATETIME (I can’t change to date only, because I need the time in a few moments). So I’m trying to send only Date, but it returns an error.

Message = "The specified type Member 'Date' is not supported in LINQ to Entities. Only initializers, Entity Members, and Entity navigation properties are supported."

var query = from td in this.Table.AsNoTracking()
                    join u in base.context.Users on  td.UserId equals u.Id
                    where (!onlyEnabled) || (u.Enable)
                    select td;
            //AQUI TENTO PASSAR APENAS O DATE
        if (initialOpeningDate.HasValue)
            query = query.Where(td => DbFunctions.TruncateTime(td.OpeningDate.Date) >= initialOpeningDate.Value);
          //AQUI TENTO PASSAR APENAS O DATE
        if (finalOpeningDate.HasValue)
            query = query.Where(td => DbFunctions.TruncateTime(td.OpeningDate.Date) <= finalOpeningDate.Value);

        if (onlyExpired)
            query = query.Where(td => td.ExpireDate < DateTime.Now);

        return query.ToList();

Answer 1

Your approach is correct, using DbFunctions.TruncateTime, but I believe you may not pass the conversion into the Linq sentence, solving the variables before, as follows:

    if (initialOpeningDate.HasValue) 
    {
        var queryInitialOpeningDate = initialOpeningDate.Value.Date;
        query = query.Where(td => DbFunctions.TruncateTime(td.OpeningDate.Date) >= queryInitialOpeningDate);
      //AQUI TENTO PASSAR APENAS O DATE
    }
    if (finalOpeningDate.HasValue) 
    {
        var queryFinalOpeningDate = finalOpeningDate.Value.Date;
        query = query.Where(td => DbFunctions.TruncateTime(td.OpeningDate.Date) <= queryFinalOpeningDate);
    }