Dapper Contrib - Easy CRUD Method

So far, we have looked at CRUD operations by implementing the operations ourselves using SQL.

Dapper Contrib takes it up one step further and provides us with a neat methods to do the CRUD tasks for us.

For example - notice the difference between GetAll() and UpdateAll()

UserRepository.cs

Dapper.Contrib has the following Generic Members available to us:

T Get<T>(id);
IEnumerable<T> GetAll<T>();
int Insert<T>(T obj);
int Insert<T>(Enumerable<T> list);
bool Update<T>(T obj);
bool Update<T>(Enumerable<T> list);
bool Delete<T>(T obj);
bool Delete<T>(Enumerable<T> list);
bool DeleteAll<T>();

Dapper.Contrib Generic Members

For a more detailed breakdown of what the code does, you can refer to the Dapper repository on Github, its open source which is fantastic!

StackExchange/Dapper

Dapper - a simple object mapper for .Net. Contribute to StackExchange/Dapper development by creating an account on GitHub.

StackExchangeGitHub