Dapper.FluentExecution 0.1.0

Dapper - Fluent Execution

This package is a simple, easy and fluent way to execute SQL on database connection by Dapper.

Installation

You can install the package using one of the options bellow:

• Package Manager

PM> NuGet\Install-Package Dapper.FluentExecution -Version 0.1.0

• .NET CLI

dotnet add package Dapper.FluentExecution --version 0.1.0

• PackageReference

<PackageReference Include="Dapper.FluentExecution" Version="0.1.0" />

Usage

Simple query:

public async Task<List<Person>> GetAllAsync(CancellationToken cancellation = default)
{
    return await "SELECT * FROM Persons"
        .On(DatabaseConnection)
        .QueryAsync<Person>(cancellation)
        .ToListAsync();
}

Querying with parameter:

public async Task<Person?> GetByIdAsync(int id, CancellationToken cancellation = default)
{
    return await "SELECT * FROM Persons where Id = @Id"
        .On(DatabaseConnection)
        .WithParameter("@Id", id)
        .QuerySingleOrDefault<Person>(cancellation);
}

Querying with conditional parameter and append:

public async Task<Person?> GetByIdAsync(int id, int? specificAddressId, CancellationToken cancellation = default)
{
    return await "SELECT p.* FROM Persons p inner join Addresses a on a.PersonId = p.Id where Id = @Id"
        .On(DatabaseConnection)
        .AppendSql(specificAddressId.HasValue, "AND a.Id = @AddressId")
        .WithParameter(specificAddressId.HasValue, "@AddressId", specificAddressId)
        .WithParameter("@Id", id)
        .QuerySingleOrDefault<Person>(cancellation);
}

TODO - v0.1.0

• Describe all classes/methods with summaries
• Create pipeline yml on Github
• Finish the Usage topic on README
• Create a Github repository to push code
• Create an integration test