COUNT keyword

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

SQL Examples

db.ExecuteQuery("SELECT COUNT Person WHERE LastName LIKE 'Pe%'")

With TOP and SKIP

db.ExecuteQuery("SELECT COUNT SKIP 2 TOP 3 Person WHERE LastName LIKE 'Pe%'")

LINQ Example (database natively supports Count)

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