Translate the new LINQ Order/OrderDescending

[roji]

See blog post.

These new methods aren't useful over entities, but can be useful after the user has projected from the entity to some column and wants to order that. Should be pretty trivial.

[smitpatel]

I wonder if we should just convert to OrderBy(e => e) in pre-translation phase.

[roji]

Yep, that seems easiest...

[smitpatel]

May be we should let users do that through interceptors.

[roji]

That would certainly be the workaround until we do this 🤣

[smitpatel]

This API is in .NET 7 only and we are still on net6.0 tfm

[roji]

Note: we already support OrderBy(x => x) on entity types (orders by the primary key), so it should be OK to do the same with the above.