COUNT keyword

To get amount of objects that query will return a COUNT keyword can be used

SQL Examples

SELECT COUNT Dynamic WHERE LastName LIKE 'Pe%'

With DISTINCT

SELECT COUNT DISTINCT LastName FROM Dynamic WHERE LastName LIKE 'Pe%'

With TOP and SKIP

SELECT COUNT DISTINCT SKIP 2 TOP 3 LastName FROM Dynamic WHERE LastName LIKE 'Pe%'

LINQ Example (database natively supports Count)

(from Dynamic d in db where d["Number"] == 255 select d).Count()

With DISTINCT

(from Dynamic d in db where ((string)d["LastName"]).StartsWith("Pe") select d).Distinct("LastName").Count()