What do you call the cast() function of the database in the ORDER method of a database in a LINQ expression in C# C#?

Question

I have a field that stores DATETIME in my database. However I need to ignore the time of this field when I am ordering for it. The following code makes my search:

public virtual async Task<(List<TModel>, int)> FindAsync(IQueryable<TModel> query, int pageNumber = 1, int pageSize = 20, string[] sortExpression = null, Expression<Func<TModel, object>> includes = null)
    {
        query = Includes(includes, query);
        query = SetFilterAll(query);

        var count = await query.CountAsync();
        query = Sort(sortExpression, query);
        query = Pagination(pageNumber, pageSize, query);
        return (await query.ToListAsync(), count);
    }

I would like to send in the parameter sortExpresion something like, CAST(meu_campo_date AS DATE) So that in the end it would execute an SQL similar to this:

SELECT * FROM MinhaTabela ORDER BY CAST(meu_campo_date AS DATE) DESC

Answer 1

You can use the property Datetime.Date. See the example below:

using System;

public class Program
{
    public static void Main()
    {
        var dateTime = DateTime.Now;
        Console.WriteLine("Isto irá imprimir a data e hora: {dateTime}");
        Console.WriteLine("Isto irá imprimir apenas a data: {dateTime.Date}");
    }
}

See this example in . NET Fiddle: https://dotnetfiddle.net/jixgMY