How do you make AutoQuery sort case-insensitive?

ServiceStack Auto Query
1

Simple question here:

When I sort a dataset using AutoQuery like this:

/mappings?orderBy=Name

I get a list of results ordered like so:

AAAA
BBBB
CCCC
aaa
bbb
ccc

I’d prefer things be sorted like so:

aaa
AAAA
bbb
BBBB
ccc
CCCC

Is there a way to change the configuration of AutoQuery so that my documents are sorted in a case-insensitive manner? Alternatively is there a way to change my query to accomplish this?

Many thanks!

-Z

[EDIT]
It occurs to me that this might be an OrmLite configuration issue.

We’re using ServiceStack.OrmLite.Sqlite and Mono.Data.Sqlite.

Our connection string is simply: “c:\temp\data.sqlite”

2

The results of Order By is dependent on the collation of the table, if it’s not using a case-insensitive collation you would need to add Custom SQL which you can only do with a Custom AutoQuery implementation, e.g:

public class QueryMappings : QueryDb<Mapping> { }

//Custom implementation
public object Any(QueryMappings dto)
{
    var q = AutoQuery.CreateQuery(dto, Request);
    if (q.OrderByExpression != null)
        q.OrderByExpression += " COLLATE NOCASE";

    return AutoQuery.Execute(dto, q);
}