Top

Top works when appended to the SqlQuery at any point prior to the execution call:[Test] public void ExecSelectTop_Ten() { SubSonic.SqlQuery query = DB.Select().Top("10") .From("Customers"); int records = query.ExecuteTypedList().Count; Assert.AreEqual(10, records); }
Note: This query will not work if you execute GetRecordCount