get distinct values in LINQ query

Question

I wrote this query:

            var queryDetails = DbContext.ProductEventNotificationDetails.Where(p 
                 =>p.ProductEventNotifications_Id == ID).ToList().Select(r => new
                        {
                            r.Id,
                            NotificationMethod = 
                               r.NotificationContact.NotificationMethod.Name

                        });

So, i need to get only distinct values based on NotificationMethod value. If I use distinct() at the end, it schedules according to Id. Can you please let me know how to accomplish this?

kenwarner · Accepted Answer · 2012-05-29 20:19:21Z

1

var queryDetails = DbContext.ProductEventNotificationDetails
    .GroupBy(x => x.NotificationMethod)
    .Select(group => group.Key);

answered May 29, 2012 at 20:19

kenwarner

29.2k31 gold badges133 silver badges174 bronze badges

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

Collectives™ on Stack Overflow

get distinct values in LINQ query

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