LINQ Select Distinct Count in Lambda form

c# linq select lambda distinct
Kyle picture Kyle · Jul 7, 2011 · Viewed 33.4k times · Source

Given a linq expression of an object collection 'items' such as this:

var total = (from item in items select item.Value).Distinct().Count()

Is it possible to convert this to use linq functions/lambdas:

items.Select(???).Distinct().Count()

Answer

Daniel Hilgarth picture Daniel Hilgarth · Jul 7, 2011

Use this:

items.Select(i => i.Value).Distinct().Count()

Related questions

How to get values from IGrouping

I have a question about IGrouping and the Select() method. Let's say I've got an IEnumerable<IGrouping<int, smth>> in this way: var groups = list.GroupBy(x => x.ID); where list is a List<…

Read More
Using LINQ, select list of objects inside another list of objects

public class ClassA { public string MyString {get; set;} } public class ClassB { public List<ClassA> MyObjects {get; set;} } List<ClassB> classBList = new List<ClassB>(); var results = (from i in classBList select i.MyObjects).Distinct(); I …

Read More
How to handle null values in linq?

recordsList.ListOfRecords = new StudentRecordsBAL() .GetStudentsList() .Select(q => new StudentRecords() { _RollNumber = q._RollNumber, _Class = q._Class, _Name = q._Name, _Address = q._Address, _City = q._City, _State = q._State, _Subjects = q._Subject, _AttendedDays = new AttendanceBAL() .GetAttendanceListOf(q._RollNumber) .Where(date => …

Read More