How to force LINQ Sum() to return 0 while source collection is empty

by

Try changing your query to this:

db.Leads.Where(l => l.Date.Day == date.Day
            && l.Date.Month == date.Month
            && l.Date.Year == date.Year
            && l.Property.Type == ProtectedPropertyType.Password
            && l.Property.PropertyId == PropertyId)
         .Select(l => l.Amount)
         .DefaultIfEmpty(0)
         .Sum();

This way, your query will only select the Amount field. If the collection is empty, it will return one element with the value of 0 and then the sum will be applied.

More Related Contents:

  1. VB Net Class in C# [closed]
  2. How do I apply OrderBy on an IQueryable using a string column name within a generic extension method?
  3. A circular reference was detected while serializing an object of type ‘SubSonic.Schema .DatabaseColumn’.
  4. The cast to value type ‘Int32’ failed because the materialized value is null
  5. What difference does .AsNoTracking() make?
  6. What is the purpose of self tracking entities?
  7. LINQ to Entities does not recognize the method ‘Double Parse(System.String)’ method, and this method cannot be translated into a store expression
  8. Making Entity Class Closed for Changes
  9. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  10. Filter/Search using Multiple Fields – ASP.NET MVC
  11. linq to entities doesn’t recognize a method
  12. EF Data Context – Async/Await & Multithreading
  13. Why would try/finally rather than a “using” statement help avoid a race condition?
  14. Retrieve an object from entityframework without ONE field
  15. How can I disable model compatibility checking in Entity Framework 4.3?
  16. Finding the reason for DBUpdateException
  17. DbContext discard changes without disposing
  18. Entity Framework 4: How to find the primary key?
  19. .Include() vs .Load() performance in EntityFramework
  20. Max return value if empty query
  21. Group by with multiple columns using lambda
  22. How to do an “in” query in entity framework?
  23. Parallel doesnt work with Entity Framework
  24. big issue in converting string to datetime using linq-to-entities
  25. Entity Framework: Duplicate Records in Many-to-Many relationship
  26. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception
  27. Entity Framework Multiple Object Contexts
  28. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  29. How to include() nested child entity in linq
  30. LINQ Query to Convert string to datetime

Leave a Comment