Grouping in LINQ - simple question

Question

I'm trying to get a list of the unique values from a field called 'domain' using the query below. Instead of just giving me the values themselves, my dropdown (drpDomain) contains values in this format: {Key = LNAU} etc. All I want to see is the value itself. Am I missing something obvious? Thanks!

var domainList = from v in db.Vendors
                         group v by new {v.Domain} into g
                         select g.Key;

        drpDomain.DataSource = domainList;
        drpDomain.DataBind();

No g.Value seemed to be available. Thanks for the comment though :) — Glinkot
– Glinkot, Commented Aug 16, 2010 at 4:56
In Linq, grouping actually returns groups (IGrouping), unlike SQL groupings which basically returns the "headers" of groups. — SirDemon
– SirDemon, Commented Aug 16, 2010 at 4:57

kbrimington · Accepted Answer · 2010-08-16 05:37:43Z

4

Consider this, instead:

var domainList = from v in db.Vendors
                 select v.Domain;

drpDomain.DataSource = domainList.Distinct();
drpDomain.DataBind();

Note:

The real villain in your query is the anonymous object; however, the distinct query is more effective in communicating the intent, and may even be more efficient. That said, if you want only to fix the unexpected results of the grouping query, try this:

var domainList = from v in db.Vendors
                 group v by v.Domain into g
                 select g.Key;

edited Aug 16, 2010 at 5:37

answered Aug 16, 2010 at 4:46

kbrimington

25.7k5 gold badges67 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

Grouping in LINQ - simple question

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related