Dapper

    Dapper extends the IDbConnection by providing useful extension methods to query your database.

    How Dapper Works?

    It is a three-step process.

    • Create an IDbConnection object.
    • Pass query as a parameter in the Execute method.

    Requirement

    Dapper works with any database provider since there is no DB specific implementation.

    Dapper will extend your IDbConnection interface with multiple methods:

    Parameter

    Execute and queries method can use parameters from multiple different ways:

    The result returned by queries method can be mapped to multiple types:

    Utilities