Dapper Review

74 12

Review of Dapper powered by the Slant community.

Works across all .NET ADO providers including SQLite, SQL CE, Firebird, Oracle, MySQL, PostgreSQL and SQL Server.
Read article: Using Dapper Flexibly.

Ranked in these QuestionsQuestion Ranking

What are the best ORMs for C#?

Pros

Pro
Very efficient and quick

Pro
No need to roll your own conversion layer for the DataReader

Pro
Similar performance to a raw SqlCommand with DataReader and parsing

Pro
Makes it trivially easy to turn results into objects

Pro
Makes it trivially easy to execute queries (scalar, multi-rows, multi-grids, and no-results)

Pro
Makes it trivially easy to correctly parameterize queries

Cons

Con
Not even slightly typesafe

If you make a typo in the SQL your CI server is not going to catch it, you'll have to hope it's caught during automated UI or functional testing.

Con
A pain to maintain

You've got a bunch of inline SQL statements that do various queries that have no strong ties to the DB architecture. This can quite easily lead to queries that get "left behind" when the underlying DB structure changes, which, again, you will not see at build time.