Model-level query sortings

[MarcoLoetscher]

It would be very handy if sortings could be defined model-based.

Fluent API:
modelBuilder.Entity<Post>().HasQuerySortOrderAsc(p => p.Title);
modelBuilder.Entity<Post>().HasQuerySortOrderAsc(p => p.Title).HasQuerySortOrderDesc(p => p.Content);

Data Annotations:
[QuerySortOrderAsc] public string Title { get; set; }
or
[QuerySortOrderAsc(1)] public string Title { get; set; }
[QuerySortOrderDesc(2)] public string Content { get; set; }

Using:
var posts = context.Posts.Where(p => p.Title.StartsWith("a").ToList(); //Without the OrderBy method, "model-level query sorting" should be used
or
var blogs = context.Blogs.Include(blog => blog.Posts).ToList(); //"model-level query sorting" should be used
or
context.Entry(blog).Collection(b => b.Posts).Load(); //"model-level query sorting" should be used

Thanks Marco

[ajcvickers]

Note for triage: I was not able to find this on the backlog, so putting it there.

[smitpatel]

duplicate of #7450 ?

[ajcvickers]

Nice find, @smitpatel. You cal it sorting I call it ordering, let's call the whole thing off. ;-)