Hi.
I am using
- llblgen v4.2 Final, April 10th, 2015
- adapter pattern
- sql server 2012 R2
I want to achieve this:
select * from [process] order by [Title] collate Danish_Norwegian_CI_AS asc
I tried with this, but it does not work
var collate = new DbFunctionCall("{0} collate Danish_Norwegian_CI_AS", new object[] { ProcessFields.Title });
adapter.FetchEntityCollection(processes, filter, -1, new SortExpression(ProcessFields.Title.SetExpression(collate) | SortOperator.Ascending), prefetch);
Any suggestions?