Group by C# Concat?

Question

I need to have endResult to be in descending order by ID and am not sure how that works with c# Linq. Any help would be great.

private void textBox6_Leave(object sender, EventArgs e)
{
    DataClasses3DataContext db = new DataClasses3DataContext();

    int matchedAdd = (from c in db.GetTable<prop>()
                      where c.streetNum.Contains(textBox1.Text) && c.Direction.Contains(textBox2.Text) && c.street.Contains(textBox4.Text) && c.SUFF.Contains(textBox6.Text)
                      select c.ID).Single();

    var before = (from c in db.GetTable<prop>()
                  where c.ID < matchedAdd
                  orderby c.PARCEL descending
                  select c).Take(6);

    var after = (from c in db.GetTable<prop>()
                 where c.ID > matchedAdd
                 orderby c.PARCEL
                 select c).Take(6);

    var endResult = after.Concat(before);

    dgvBRT.DataSource = endResult;

}

Possible duplicate: http://stackoverflow.com/questions/298725/multiple-order-by-in-linq — Jente Rosseel, Apr 29 '13 at 17:23
Sounds like you didn't even try to solve this problem. Did you look around at *all* as to how to order a sequence using LINQ? — Servy, Apr 29 '13 at 17:25
@Servy yep I didn't bother to do anything. I just came here and posted without even the slightest attempt . — korrowan, Apr 29 '13 at 17:46
@korrowan Where did you look? What did you try? What happened as a result of those attempts? Did you get errors, were they compile time or runtime, did you get incorrect outputs, etc? There are *thousands* of tutorials on this subject, so there is a *lot* of information out there that demonstrates *exactly* how to do this. — Servy, Apr 29 '13 at 17:48

score 2 · Accepted Answer · answered Apr 29 '13 at 17:23

2

dgvBRT.DataSource = endResult.OrderByDescending(x => x.ID);

...there's not much else to say.

answered Apr 29 '13 at 17:23

spender

117,338
33
229
351

Thanks guys. I wasn't sure where to put the orderby..thanks! – korrowan Apr 29 '13 at 17:25

score 1 · Answer 2 · answered Apr 29 '13 at 17:23

1

This may helps:

after.Concat(befor).OrderByDescending(i => i.ID);

answered Apr 29 '13 at 17:23

Hossein Narimani Rad

31,361
18
86
116

Group by C# Concat?

2 Answers2