LINQ Multiple Order By

Question

I have 3 tables Pamphlets, Categories and Program. The Pamphlet table has a CategoryID and ProgramID column. The following code works:

var pamphlets = db.Pamphlets.Include("Category").Include("Program").ToList();

What I need to do is sort by CategoryName (Category table) and then PamphletName (Pamphlet table).

possible duplicate of Multiple "order by" in LINQ

nawfal
– nawfal

2013-10-24 13:09:12 +00:00
Commented Oct 24, 2013 at 13:09 — nawfal
– nawfal, Commented Oct 24, 2013 at 13:09

Justin Niessner · Accepted Answer · 2011-06-07 19:14:21Z

7

You would simply chain a call to ThenBy():

var sortedPamphlets = db.Pamphlets.Include("Category").Include("Program")
                        .OrderBy(p => p.Category.CategoryName)
                        .ThenBy(p => p.PamphletName)
                        .ToList();

answered Jun 7, 2011 at 19:14

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

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

3 Comments

Snowbear Over a year ago

Wouldn't it be better to place OrderBy before ToList to give database a chance?

Justin Niessner Over a year ago

@Snowbear JIM-compiler - We had the same thought at the same time. Just made the change before I saw your comment.

Jason MacKenzie Over a year ago

Thanks! I really appreciate that. I knew it must be something simple.

BrokenGlass · Accepted Answer · 2011-06-07 19:15:03Z

1

How about:

var pamphlets = (from p in db.Pamphlets.Include("Category").Include("Program")
                orderby p.Category.CategoryName, p.PamphletName
                select p).ToList();

answered Jun 7, 2011 at 19:15

BrokenGlass

161k28 gold badges297 silver badges339 bronze badges

Comments

Jay · Accepted Answer · 2011-06-07 19:15:42Z

1

Try this:

var pamphlets = (from i in db.Pamphlets.Include("Category").Include("Program")
                 orderby i.Category.CategoryID, i.PamphletName
                 select i).ToList();

answered Jun 7, 2011 at 19:15

Jay

6,3044 gold badges22 silver badges23 bronze badges

Collectives™ on Stack Overflow

LINQ Multiple Order By

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related