How I can order desc **nulls to last **on entity view like this query ? my database is oracle.

select  t.Last_Visit_Date from patients_index_v t
order by  t.Last_Visit_Date  desc nulls last; 

Please check the following thread: http://llblgen.com/TinyForum/Messages.aspx?ThreadID=13532

Hi Walaa, Is there any way to tell to LLBLGEN to create queries with instant nulls last I'm working with FetchTypedView. Can I set nulls last behavior with LLGLGEN.

Thank you.

You may derive from the SortExpression and override the ToQueryText method.

e.g. cn be found here: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=14414

Thank you! Overriding SortExpression solves our problem!

 public class DerivedSortExpression : SortExpression
    {
        public override string ToQueryText(ref int uniqueMarker, bool aliasesForExpressionsAggregates)
        {
            return base.ToQueryText(ref uniqueMarker, aliasesForExpressionsAggregates).Replace("DESC","DESC NULLS LAST").Replace("ASC","ASC NULLS FIRST");
        }
    }