How do I get the MAX row with a GROUP BY in LINQ query?

by 
        using (DataContext dc = new DataContext())
        {
            var q = from t in dc.TableTests
                    group t by t.SerialNumber
                        into g
                        select new
                        {
                            SerialNumber = g.Key,
                            uid = (from t2 in g select t2.uid).Max()
                        };
        }

More Related Contents:

  1. LINQ: When to use SingleOrDefault vs. FirstOrDefault() with filtering criteria
  2. LINQ to SQL Left Outer Join
  3. Why use LINQ Join on a simple one-many relationship?
  4. How to use “contains” or “like” in a dynamic linq query?
  5. What can I do to resolve a “Row not found or changed” Exception in LINQ to SQL on a SQL Server Compact Edition Database?
  6. LINQ to Entities does not recognize the method
  7. Which method performs better: .Any() vs .Count() > 0?
  8. Entity Framework vs LINQ to SQL
  9. Is it better to call ToList() or ToArray() in LINQ queries?
  10. Why is LINQ JOIN so much faster than linking with WHERE?
  11. Linq to Entities – SQL “IN” clause
  12. LINQ on the .NET 2.0 Runtime
  13. Wrap a delegate in an IEqualityComparer
  14. Linq int to string
  15. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  16. .NET List Concat vs AddRange
  17. LINQ Where Ignore Accentuation and Case
  18. Sequential GUID in Linq-to-Sql?
  19. Max or Default?
  20. Why does IQueryable.All() return true on an empty collection?
  21. How do I do a left outer join with Dynamic Linq?
  22. How to Convert LINQ Comprehension Query Syntax to Method Syntax using Lambda
  23. Why are some object properties UnaryExpression and others MemberExpression?
  24. List, IList, IEnumerable, IQueryable, ICollection, which is most flexible return type?
  25. Last and LastOrDefault not supported
  26. LinqToSql declare and instantiate DataContext best practice?
  27. How to perform merge sort using LINQ?
  28. Linq: What is the difference between Select and Where
  29. Do you think it’s advantageous to switch to Entity Framework? [closed]
  30. How to Convert Row to Column in Linq and SQL

Leave a Comment