DapperMan 1.0.0

DapperMan

A simple set of wrappers for Dapper to generate small SQL statements. Similar in concept to what you'll find in Dapper.Contrib, but with a consistent API and extra features.

Documentation

View the full documentation on github.

Basic Example

This generates a simple select statement. The result is an IEnumerable<T>, and TotalRows represents the length of the results.

(IEnumerable<Department> depts, int totalRows) = DapperQuery
    .Select("HumanResources.Department", connectionString)
    .Where("GroupName = @groupName")
    .Where("DepartmentName != @excludeDept")
    .OrderBy("GroupName")
    .OrderBy("DepartmentName")
    .Execute<Department>(new { groupName = "foo", excludeDept = "bar" });

You can also write your Where and OrderBy statements like this if you prefer:

    .Where("GroupName = @groupName AND DepartmentName != @excludeDept)
    .OrderBy("GroupName, DepartmentName")

Both will generate the same SQL (formatted for readability)

SELECT *
FROM HumanResources.Department
WHERE GroupName = @groupName
    AND DepartmentName != @excludeDept
ORDER BY GroupName, DepartmentName