PvWayDaoAbstractions 1.0.0

pvWay DAO services abstractions .Net Core 6

This nuGet defines the interfaces for tiny DAO services.

It includes the following interfaces

It comes along with some concrete implementations such as PvWayMsSqlDao, PvWayPgSqlDao...

Interfaces

IDaoService

The DaoService interface contains the contract for two main classes:

• StoredProcExecutor that implements IDaoStoredProcExecutor
• TextCommandExecutor that implements IDaoTextCommandExecutor

Three async methods enable to wrap commands into transactions:

• BeginTransactionAsync
• CommitTransactionAsync
• RollbackTransactionAsync

public interface IDaoService : IAsyncDisposable
{
    string GetDatabaseName();
    IDaoStoredProcExecutor StoredProcExecutor { get; }
    IDaoTextCommandExecutor TextCommandExecutor { get; }
    Task<IDbTransaction> BeginTransactionAsync();
    Task CommitTransactionAsync();
    Task RollbackTransactionAsync();
}

IDaoCommandExecutor

This interface includes two simple methods

• CreateCommand within or without an associated transaction
• Execute a command that returns a scalar object

public interface IDaoCommandExecutor
{
    IDbCommand CreateCommand(string commandText,
        IDbTransaction? transaction = null);
    Task<object?> ExecuteScalarAsync(IDbCommand cmd);
}

IDaoTextCommandExecutor

This extends the IDaoCommandExecutor with two async methods

• Execute Reader, a generic that returns a IEnumerable of object by passing a command and a factory
• Execute NonQueryAsync that executes a command

public interface IDaoTextCommandExecutor : IDaoCommandExecutor
{
    Task<IEnumerable<T>> ExecuteReaderAsync<T>(
        Func<IDaoReader, T> factor,
        IDbCommand cmd);

    Task ExecuteNonQueryAsync(IDbCommand cmd);
}

IDaoStoredProcExecutor

This extends the IDaoTextCommandExecutor with one method enabling to pass some string parameters to the stored proc

public interface IDaoStoredProcExecutor : IDaoTextCommandExecutor
{
    void AddStringParam(IDbCommand cmd, string paramName, string paramValue);
    // feel free to add more param types if needed
}

Enjoy it:=)