LINQ and the Count extension method

Question

I have a database table which could contain many records and I'd like to count the current total in the table. I was going to do a simple:

DataContext.Table.Count(c => c.condition);

Until I realized the return type for Count is int. What if the table is to hold more values than can be represented in 32 bits? How can I count them?

Should I be counting them in a different way when we're talking about that kind of scale?

Answer 1

My solution was to use the .LongCount() extension method.

Answer 2

Use LongCount(), same thing but with a 64 bit result.