DataAbstractions.DapperParameters 1.0.0

DataAbstractions.DapperParameters

A library for building Dapper dynamic parameters with a simple a fluent API.

Extension Methods

CreateParameters() extension method will turn each property into a dynamic parameter using the property name and value.

public class MyObject
{
    public int Id {get; set; }
    public string Name { get; set; }
    public DateTime ModifiedDate { get; set; }
}

var parameters = myObject.CreateParameters();

To customize parameters, use Parameterize() to add, remove, and replace with a fluent syntax.

var parameters = myObject.Parameterize()
                         .Add("NewId", myIdentifier)
                         .Remove(x => x.Name)
                         .Replace(x => x.ModifiedDate, DateTime.Now)
                         .Create();

connection.Execute("myStoredProcedure", parameters, commandType: CommandType.StoredProcedure);                         

IParameterBuilder Interface

An IParameterFactory interface is available for projects leveraging dependency injection. This interface has the same API method signatures as the extension methods above.

IParameterFactory parameterFactory = new ParameterFactory();

var parameters = parameterFactory.Parameterize(myObject)
                         .Add("NewId", myIdentifier)
                         .Remove(x => x.Name)
                         .Replace(x => x.ModifiedDate, DateTime.Now)
                         .Create();

TODO:

• Create fluent API for customizing and creating Table Valued Parameters