Asp.Net MVC - Linq Sorting Question

Question

I have a MVC application that I'm near completing. But I have a situation that cannot figure out the syntax for.

What I want to do is to sort on two columns When I use the syntax below, it sorts by one column, then the next.

        public IQueryable<vw_FormIndex> FindAllFormsVw(int companyIdParam)
    {
        return _db.vw_FormIndexes.Where(d => d.companyID == companyIdParam).OrderBy(d => d.formSortOrder).OrderBy(d => d.formCustNumber);
    }

Suggestions Please

JamieGaines · Accepted Answer · 2009-08-13 15:41:44Z

5

I think you want ThenBy

public IQueryable<vw_FormIndex> FindAllFormsVw(int companyIdParam)
{
    return _db.vw_FormIndexes.Where(d => d.companyID == companyIdParam).OrderBy(d => d.formSortOrder).ThenBy(d => d.formCustNumber);
}

Comments

Craig Stuntz · Accepted Answer · 2009-08-13 15:41:46Z

3

Use .OrderBy().ThenBy();

answered Aug 13, 2009 at 15:41

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

Comments

orip · Accepted Answer · 2009-08-13 15:42:57Z

0

Maybe ThenBy?

_db.vw_FormIndexes.Where(d => d.companyID == companyIdParam).OrderBy(d => d.formSortOrder).ThenBy(d => d.formCustNumber);

answered Aug 13, 2009 at 15:42

orip

76k21 gold badges120 silver badges150 bronze badges

Collectives™ on Stack Overflow

Asp.Net MVC - Linq Sorting Question

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related