Linq query with nullable sum

by

You want to use the nullable form of Sum, so try casting your value to a nullable:

from i in Db.Items
select new VotedItem
{
    ItemId = i.ItemId,
    Points = (from v in Db.Votes
              where b.ItemId == v.ItemId
              select v.Points).Sum(r => (decimal?) r.Points)
}

Your issue is discussed here in more detail:

http://weblogs.asp.net/zeeshanhirani/archive/2008/07/15/applying-aggregates-to-empty-collections-causes-exception-in-linq-to-sql.aspx

More Related Contents:

  1. Get sum of two columns in one LINQ query
  2. Sum multidimensional array over dimensions [closed]
  3. Returning IEnumerable vs. IQueryable
  4. Return anonymous type results?
  5. How can I conditionally apply a Linq operator?
  6. LINQ to SQL – Left Outer Join with multiple join conditions
  7. How to do a subquery in LINQ?
  8. Understanding .AsEnumerable() in LINQ to SQL
  9. TransactionScope vs Transaction in LINQ to SQL
  10. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  11. LINQ: combining join and group by
  12. How to write Asynchronous LINQ query?
  13. Compare nullable types in Linq to Sql
  14. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  15. How do you perform a CROSS JOIN with LINQ to SQL?
  16. LINQ Where Ignore Accentuation and Case
  17. Operation could destabilize the runtime?
  18. How to select only the records with the highest date in LINQ
  19. Custom Method in LINQ to SQL query
  20. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  21. LINQ Expression to return Property value?
  22. Max or Default?
  23. Will using LINQ to SQL help prevent SQL injection
  24. How do I do a left outer join with Dynamic Linq?
  25. Last and LastOrDefault not supported
  26. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  27. Accessing System Databases/Tables using LINQ to SQL?
  28. Is Injection Possible through Dynamic LINQ?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment