如何在EfCore中用原始SQL编写orderBy查询？

using Microsoft.EntityFrameworkCore;

public class MyDbContext : DbContext
{
    public DbSet<MyEntity> MyEntities { get; set; }

    public MyDbContext(DbContextOptions<MyDbContext> options) : base(options)
    {
    }

    public List<MyEntity> GetEntitiesOrderedBy(string columnName, string sortOrder)
    {
        string sql = $"SELECT * FROM MyEntities ORDER BY {columnName} {sortOrder}";
        return MyEntities.FromSqlRaw(sql).ToList();
    }
}

public class MyEntity
{
    public int Id { get; set; }
    public string Name { get; set; }
    // other properties
}