Max return value if empty query

by 
int maxShoeSize = Workers.Where(x => x.CompanyId == 8)
                         .Select(x => x.ShoeSize)
                         .DefaultIfEmpty(0)
                         .Max();

The zero in DefaultIfEmpty is not necessary.

More Related Contents:

  1. How to convert an expression tree to a partial SQL query?
  2. Linq: help me to make this work
  3. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  4. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  5. Entity Framework/Linq EXpression converting from string to int
  6. Filter/Search using Multiple Fields – ASP.NET MVC
  7. Can I specify my explicit type comparator inline?
  8. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  9. Entity Framework – Cannot convert lambda expression to type ‘string’ because it is not a delegate type
  10. LINQ – Query syntax vs method chains & lambda [closed]
  11. Join and Include in Entity Framework
  12. Group by with multiple columns using lambda
  13. Remove item from list based on condition
  14. How to do an “in” query in entity framework?
  15. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  16. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  17. How to include() nested child entity in linq
  18. Should the order of LINQ query clauses affect Entity Framework performance?
  19. LINQ Query to Convert string to datetime
  20. Get All instead of FirstOrDefault
  21. How to write this nested foreach loop query in LINQ?
  22. Linq: GroupBy, Sum and Count
  23. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  24. Lambda variable capture in loop – what happens here? [duplicate]
  25. Extension methods syntax vs query syntax
  26. Internal .NET Framework Data Provider error 1025
  27. Should I use two “where” clauses or “&&” in my LINQ query?
  28. Entity Framework Code Only error: the model backing the context has changed since the database was created
  29. Performance of Find() vs. FirstOrDefault() [duplicate]
  30. Update records using LINQ

Leave a Comment