Linq distinct – Count

by 
logins
  .GroupBy(l => l.Date)
  .Select(g => new
  {
    Date = g.Key,
    Count = g.Select(l => l.Login).Distinct().Count()
  });

More Related Contents:

  1. Get a list greater than specific value from lists usinq linq c#
  2. System.Linq.Expression.Compile error
  3. LEFT OUTER JOIN in LINQ
  4. Remove duplicates in the list using linq
  5. Sort a list from another list IDs
  6. When to use Cast() and Oftype() in Linq
  7. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  8. How do I concatenate two arrays in C#?
  9. How to perform Join between multiple tables in LINQ lambda
  10. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  11. LINQ: Select an object and change some properties without creating a new object
  12. For vs. Linq – Performance vs. Future
  13. How to flatten nested objects with linq expression
  14. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  15. How to write Asynchronous LINQ query?
  16. LINQ to Entities does not recognize the method ‘Int32 Int32(System.String)’ method, and this method cannot be translated into a store expression
  17. How do you perform a CROSS JOIN with LINQ to SQL?
  18. LIKE operator in LINQ
  19. Nested “from” LINQ query expressed with extension methods
  20. How can I split an IEnumerable into groups of IEnumerable [duplicate]
  21. IEqualityComparer for SequenceEqual
  22. Intersect LINQ query
  23. LINQ – Query syntax vs method chains & lambda [closed]
  24. Resolving extension methods/LINQ ambiguity
  25. Is there an “Explain Query” for MongoDB Linq?
  26. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  27. Get previous and next item in a IEnumerable using LINQ
  28. Calling a SQL User-defined function in a LINQ query
  29. Select multiple fields group by and sum
  30. Linq – Top value from each group

Leave a Comment