"Order Col1, Col2" using entity structure

Question

I need to order in 2 columns using the entity infrastructure.

How it's done?

return _repository.GetSomething().OrderBy(x => x.Col1 .. Col2)? 

ie

 SELECT * FROM Foo ORDER BY Col1, Col2 

/ M

Answer 1

Try OrderBy(x => x.Col1).ThenBy(x => x.Col2) . Anyway, this is a LINQ function, not just for EF.

Answer 2

Another way:

 qqq.OrderBy(x => new { x.Col1, x.Col2} ) 

Answer 3

Try: OrderBy (x => x.Col1) .ThenBy (x => x.Col2)

Or for Descending try: OrderByDescending (x => x.Col1) .ThenByDescending (x => x.Col2)

Answer 4

Please note that this will not work with the Telerik network or any other Telerik DataSource component. Although it uses a pre-filtered IQueryable, sorting is always done automatically, since the last step effectively overrides the sorting settings.

You need to follow: Specifying default sorting in the grid