Dapper Tutorial 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; } }