URL: https://localhost:5001/owners?OrderBy=tenantId desc         

(tenantId is not a valid column in owners entity)

Exception: System.ArgumentException
Message: Value cannot be empty. (Parameter ‘ordering’)

Thank you for responding. I had already done that except for OwnerParameters.cs, after making Name nullable there, it started working. I didn’t think it got validation from that class.

Based on the JSON you provided, it seems that the [ApiController] attribute took over the request and validate it. After .NET 6, if you don’t want any property to be required, you can make it nullable:

public string? Name { get; set; }

If you do this, I think you won’t get this error. Of course, I would suggest you to read more about the ApiController attribute here https://code-maze.com/apicontroller-attribute-in-asp-net-core-web-api/ just to be sure what it does (if you are not familiar with it).

“title”: “One or more validation errors occurred.”,
    “status”: 400,
“errors”: {
        “Name”: [
            “The Name field is required.”
        ]

you need to install System.Linq.Dynamic.Core from nuget

            return entities.OrderBy(orderQuery);

I have an exception:

The type arguments for method 'Queryable.OrderBy <TSource, TKey> (IQueryable <TSource>, Expression <Func <TSource, TKey >>)' cannot be inferred from the usage. Try specifying the type arguments explicitly.

if (!entities.Any())            return entities;

Isn’t this an unecessary roundtrip to database?

Regards