Consult by Date

Question

Well I am using the EF with the following code to query it brings the query by name and type but by date not, since the time is not in my filter with the time 00:00:00 it brings correctly the time is not part of the search, but is part of the business rule.

public PaginationResult<Tabela> GetAll(ISpecification<Tabela> specification, Pagination pagination = null, Sorting sorting = null)
{
    var query = Tabela.Where(specification.SatisfiedBy());
    var result = new PaginationResult<Schedule>();

    if (sorting != null)
    {
        query = query.OrderBy(sorting.ToString());
    }
    result.TotalItems = query.Count();
    if (pagination != null)
    {
        query = query.Skip(pagination.CurrentPage * pagination.ItemsPerPage).Take(pagination.ItemsPerPage);
    }

    result.Items = query.ToList();
    return result;
}

The specification

specification = 
          specification.And(Specification<tabela>.Create(e => e.data.Equals(filter.data)));

Answer 1

If a hora não faz parte da pesquisa, I believe you can only take the date portion by adding the .Date on the date of the objects when creating Specification:

specification = specification.And(Specification<tabela>.Create(e => DbFunctions.TruncateTime(e.data) <= filter.data.Date));