How to specify default order by?

ServiceStack Auto Query
1

Given the following code

public object Get(GetTenants query)
{
    return AutoQuery.Execute(query, AutoQuery.CreateQuery(query, Request));
}

How would I specify a default order by on the Name column? I don’t want to pass this in with the request. I’d like to somehow specify this in the above block of code.

2

AutoQuery.CreateQuery() returns a populated Typed OrmLite SqlExpression<T> that can be further modifed like a normal OrmLite query, e.g:

var q = AutoQuery.CreateQuery(query, Request);
q.OrderBy(x => x.Field);
3

Does this sort it on the server?

4

Yes, it’s OrmLite’s Typed SqlExpression<T>, please read the docs for more info/examples: