How to order by two fields? [duplicate]

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(); }

gotnull · Accepted Answer · 2013-05-22 02:25:55Z

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, 2013 at 2:25

gotnull

27.2k23 gold badges143 silver badges207 bronze badges

answered May 21, 2013 at 5:49

griegs

22.8k33 gold badges132 silver badges208 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

smart boy Over a year ago

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:

TyCobb Over a year ago

@smartboy What data type is 'UserLikeProduct'? Is it an IComparable? Although that may not matter since this is trying to generate SQL

Community · Accepted Answer · 2017-05-23 11:49:17Z

1

See this question: Multiple Order By with LINQ

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

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered May 21, 2013 at 5:49

TyCobb

9,1091 gold badge36 silver badges59 bronze badges

Collectives™ on Stack Overflow

How to order by two fields? [duplicate]

2 Answers 2

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Linked

Related