How to order by two fields?

Question

How to order by StartDate and UserLikeProduct? I need to sort by StartDate but show by UserLikeProduct first.

public IEnumerable<Check> GetHomeCeeck()
{    
    return this.Query()
               .Where(c => c.IsPublish && c.IsHomepageProduct)
               .OrderBy(c => c.StartDate)
               .Take(30)
               .ToList();
}

score 2 · Answer 1 · edited May 22 '13 at 02:25

2

If I understand you correctly, you want to order by one and then the other?

use .ThenBy(lambda) after the .OrderBy(lambda).

If this is not what you meant then let me know and I'll remove this answer

.OrderBy(c => c.StartDate).ThenBy(c => c.Like)

edited May 22 '13 at 02:25

fulvio

24,168
20
122
198

answered May 21 '13 at 05:49

griegs

22,002
28
113
201

Incorrect syntax near the keyword 'asc'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'asc'. Source Error: Line 25: { Line 26: Line 27: return this.Query().Where(c => c.IsPublish && c.IsHomepageProduct).OrderBy(c=>c.StartDate).ThenBy(c=>c.UserLikeProduct).Take(30).ToList(); Line 28: } Line 29: – smart boy May 21 '13 at 06:15
1

@smartboy What data type is 'UserLikeProduct'? Is it an IComparable? Although that may not matter since this is trying to generate SQL – TyCobb May 23 '13 at 03:47

score 1 · Answer 2 · edited May 23 '17 at 11:49

1

See this question: Multiple Order By with LINQ

You need to OrderBy() and then ThenBy().

edited May 23 '17 at 11:49

Community

1
1

answered May 21 '13 at 05:49

TyCobb

8,411
1
27
47

How to order by two fields?

2 Answers2