Dapper Tutorial Contributo Dapper
Che cos'è Dapper Contrib?
Dapper Contrib estende l'interfaccia IDbConnection con ulteriori metodi CRUD.
Installazione
Dapper Contrib viene installato tramite NuGet: https://www.nuget.org/packages/Dapper.Contrib/
metodi
Dapper Contrib estendere l'interfaccia IDbConnection con ulteriori metodi CRUD:
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>();
Annotazioni di dati
Dapper Contrib consente la mappatura utilizzando le annotazioni di dati:
[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; } }