What are some good persistance libraries for .NET?

Question

I come from a Java background and am getting more into .NET, what are some good libraries to use in my DAO layers? I'm used to using MyBatis (this appears to exist but not in a real full release). I've used Hibernate, which apparently exists in .NET but I'd rather avoid a full POJO style object mapper. I'd really like a library that is query based like MyBatis. Does anyone have some suggestions?

possible duplicate of [Which ORM for .NET would you recommend?](http://stackoverflow.com/questions/132676/which-orm-for-net-would-you-recommend) — poke, Jun 26 '12 at 18:23

score 1 · Answer 1 · answered Jun 26 '12 at 18:24

1

Use the one that StackOverflow is using. Dapper.NET

answered Jun 26 '12 at 18:24

alex

74,215
9
49
57

After a quick look it looks really nice, I wonder if you can externalize the SQL so it's not in your class files. – Rocky Pulley Jun 26 '12 at 18:27
Queries and commands are defined by strings, you can externalize them. – alex Jun 26 '12 at 18:31

score 1 · Accepted Answer · answered Jun 26 '12 at 18:47

1

I really like the latest entity framework by microsoft: http://msdn.microsoft.com/en-us/data/ef.aspx. They've made great progress with it.

answered Jun 26 '12 at 18:47

Steve Stokes

1,200
18
36

score 0 · Answer 3 · answered Jun 26 '12 at 18:24

0

NHibernate in .Net can be very nice with Linq to NHibernate. While the setup can be tedious, I still think I like NHibernate more than Hibernate. (Be it because of C# vs Java is a debate)

answered Jun 26 '12 at 18:24

dwerner

6,462
4
30
44

Add FluentNhibernate with Auto Convention mappings and the tediousness of the setup goes away – BlackSpy Jun 26 '12 at 20:18
I never linked FNH. NHibernate config is just XML. I really meant getting into NHibernate initially was tedious - what files to mark as embedded, etc. There's a steep learning curve. – dwerner Jun 26 '12 at 20:54

What are some good persistance libraries for .NET?

3 Answers3