[Question] OrderBy does not work with nullable navigation properties

[khallid-itdevtech]

OrderBy works fine on non nullable navigation properties but if navigation property is nullable it doesn't work

System.Linq.Dynamic.Core.Parser.ExpressionParser.ParseArgumentList() in ExpressionParser.cs, line 1851

list = list.AsQueryable().OrderBy("site.title asc" ).ToList();

site is nullable navigation property

[JonathanMagnan]

Hello @khallid-itdevtech ,

Do you think you could provide a project sample with this issue?

It will help my developer investigate the issue more efficiently.

We already tried once but everything was working, so we might miss something.

We now always ask for a project sample even if the issue is easy to reproduce. As a free product, we must find some way to save time to offer an overall better experience for everyone and release fixes faster.

You can send it to: [email protected] if you need to keep the source private

Best Regards,

Jonathan

---

Performance Libraries
context.BulkInsert(list, options => options.BatchSize = 1000);
Entity Framework Extensions • Entity Framework Classic • Bulk Operations • Dapper Plus

Runtime Evaluation
Eval.Execute("x + y", new {x = 1, y = 2}); // return 3
C# Eval Function • SQL Eval Function

[StefH]

I think the site is a nullable navigation property in this question. So you cannot use site.title asc because site is null.

The solution is to use the NullPropagating (np) function, so I think this code should solve the issue

list = list.AsQueryable().OrderBy("np(site.title) asc" ).ToList();

[JonathanMagnan]

I was getting a different error when the site was null (Null reference exception which is was I'm expecting).

I guess we will see with his answer ;)

[khallid-itdevtech]

@StefH Thanks
list = list.AsQueryable().OrderBy("np(site.title) asc" ).ToList();
this works like charm. 👍