Max or Default?

by

Since DefaultIfEmpty isn’t implemented in LINQ to SQL, I did a search on the error it returned and found a fascinating article that deals with null sets in aggregate functions. To summarize what I found, you can get around this limitation by casting to a nullable within your select. My VB is a little rusty, but I think it’d go something like this:

Dim x = (From y In context.MyTable _
         Where y.MyField = value _
         Select CType(y.MyCounter, Integer?)).Max

Or in C#:

var x = (from y in context.MyTable
         where y.MyField == value
         select (int?)y.MyCounter).Max();

More Related Contents:

  1. LINQ – Left Join, Group By, and Count
  2. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  3. LINQ Where Ignore Accentuation and Case
  4. Operation could destabilize the runtime?
  5. How to select only the records with the highest date in LINQ
  6. DISTINCT() and ORDERBY issue
  7. How do I do a left outer join with Dynamic Linq?
  8. Get sum of two columns in one LINQ query
  9. Last and LastOrDefault not supported
  10. Linq where column == (null reference) not the same as column == null
  11. Prevent duplicates from array, based on condition [closed]
  12. Return anonymous type results?
  13. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  14. How to do a subquery in LINQ?
  15. How to get the index of an element in an IEnumerable?
  16. LINQ: Not Any vs All Don’t
  17. How to check if IEnumerable is null or empty?
  18. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  19. High memory consumption with Enumerable.Range?
  20. How to Get XML Node from XDocument
  21. Use linq to generate direct update without select
  22. Find substring in a list of strings
  23. Max return value if empty query
  24. How to do an “in” query in entity framework?
  25. LINQ: Add RowNumber Column
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. Should the order of LINQ query clauses affect Entity Framework performance?
  28. Map two lists into a dictionary in C#
  29. Is Injection Possible through Dynamic LINQ?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment