Entity framework 6.2.0 + Find

Question

Hello, I’m using a search method with Entity framework and oracle, and found a problem with dates.

In my search I use the following logic:

Find(x => x.Data_Intencao >= Periodo.Date, c => c.SubOrigem_EF);

But in my Data_Intencao She’s running the search with the date and time. If I put Data_Intencao.Date the following error is presented:

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

Answer 1

Use the method DbFunctions.TruncateTime(data) to use date and skip time.

Where(x => DbFunctions.TruncateTime(x.Data_Intencao) >= Periodo.Date && c => c.SubOrigem_EF);

Answer 2

You can simply reset the time of the Periodo.Date cut-off date or create an extended function:

 DateTime date = new DateTime(Periodo.Date.Year, Periodo.Date.Month, Periodo.Date.Day, 0,0,0);

Find(x => x.Data_Intencao >= date, c => c.SubOrigem_EF);

Or to make it more elegant:

    public class Periodo
{

    public DateTime Date { get; private set; }

    public Periodo(DateTime date)
    {
        Date = date;
    }
}

public static class DateTimeCustom
{

    public static DateTime ToZeroHora(this DateTime source)
    {
        return source.AddHours(-source.Hour).AddMinutes(-source.Minute).AddSeconds(-source.Second);

    }
}

Find(x => x.Data_Intencao >= Periodo.Date.ToZeroHora(), c => c.SubOrigem_EF);