Dapper Contrib
What's Dapper Contrib?
Dapper Contrib extend the IDbConnection interface with additional CRUD methods.
Installation
Dapper Contrib is installed through NuGet: https://www.nuget.org/packages/Dapper.Contrib/
Methods
Dapper Contrib extend your IDbConnection interface with additional CRUD methods:
var invoice = connection.Get<InvoiceContrib>(1);
var invoices = connection.GetAll<InvoiceContrib>().ToList();
var identity = connection.Insert(new InvoiceContrib {Kind = InvoiceKind.WebInvoice, Code = "Insert_Single_1"});
var isSuccess = connection.Update(new InvoiceContrib {InvoiceID = 1, Code = "Update_Single_1"});
var isSuccess = connection.Delete(new InvoiceContrib {InvoiceID = 1});
var isSuccess = connection.DeleteAll<InvoiceContrib>();
Data Annotations
Dapper Contrib allow mapping using Data Annotations:
[Table("Invoice")]
public class InvoiceContrib
{
[Key]
public int InvoiceID { get; set; }
public string Code { get; set; }
public InvoiceKind Kind { get; set; }
[Write(false)]
[Computed]
public string FakeProperty { get; set; }
}
[Table("InvoiceDetail")]
public class InvoiceDetailContrib
{
[ExplicitKey]
public int InvoiceID { get; set; }
public string Detail { get; set; }
}