Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Which Micro ORM to use? [closed]

Tags:

c#

.net

orm

Trying to decide between Dapper, Massive and PetaPoco. I do like simplicity of Dapper, flexibility of Massive and POCO support in PetaPoco but am currently procrastinating about which one to choose for my next project.

I do realise that, to a large extent, it's the matter of personal taste, but believe it will be valuable to hear some opinions on the subject, especially from people who tried more than one of these, err, libraries (what is the right term: library, file, framework?)

like image 728
georged Avatar asked Apr 29 '11 08:04

georged


People also ask

Why Dapper is micro ORM?

Dapper is an example of Micro ORM, in fact, it is called the King of Micro ORM because of its speed and ease of work. First, it creates an IDbConnection object and allows us to write queries to perform CRUD operations on the database.

What is a micro ORM?

Micro ORM is basically mapper that creates objects based on database query. It saves you sometimes load of dirty work but it usually doesn't come with any powerful features like full ORM-s do.

What is Micro ORM Dapper?

Dapper is a micro ORM or it is a simple object mapper framework which helps to map the native query output to a domain class or a C# class. It is a high performance data access system built by StackOverflow team and released as open source.


2 Answers

Try to decide which of the features you mention -- simplicity, flexibility, POCO support -- will be most useful to you and your project(s) one year from now. Which is most likely to make your work easier?

Then you'll have your answer. And if you still can't choose, pick Dapper (just a random selection I made :-) As the Cheshire Cat says, if you don't really know where you want to go, it doesn't matter which road you choose.

like image 87
Roy Dictus Avatar answered Sep 21 '22 09:09

Roy Dictus


PetaPoco's documentation seems more mature than others. It seems like it is the safest route.

like image 30
suhair Avatar answered Sep 21 '22 09:09

suhair