SqlQuery Object

    SqlQuery is an object to compose dynamic SQL SELECT queries through a fluent interface.

    Advantages

    SqlQuery offers some advantages over hand crafted SQL:

    • Reduced syntax errors as the query is checked compile time, not execution time.

    • It can generate a special query to perform paging on server types that doesn’t support it natively (e.g. SQL Server 2000)