Sign in to track progress and bookmarks.
Basic math in LINQ. These methods collapse a sequence of data into a single numeric value.
Count() returns an int (max 2.1 billion). If you are processing truly 'Big Data' (like a logging table or financial transactions), use LongCount() which returns a long (64-bit integer).
Calculates the total of a numeric sequence. **Architect Note:** Sum will throw an exception if the sequence contains null values (for Nullable types), unless you handle them. For decimal?, Sum returns 0 if the list is empty, which is usually exactly what you want for financial reports.
Q: "Is Count() on IQueryable fast?"
Architect Answer: "Yes. EF Core translates .Count() into a SELECT COUNT(*) SQL query. This is extremely fast because the database doesn't have to send any row data back—it just sends the single number. Always do your counting on the database sideWhenever possible."
Quizzes linked to this course—pass to earn certificates.
On this page
1. Count vs LongCount 2. The 'Sum' Method 3. Architect Insight