Simple question here:
When I sort a dataset using AutoQuery like this:
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?
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”