Object/Relational persistency mapping frameworks for .Net

[Guy Mahieu]

Hello all,

I am currently laying the baseline for a relatively small, single tier
application in which a small number of workstations will retrieve their data
from a MySQL database on a central machine. As a Java developer I thought
this project would be a good chance to give .NET and C# a try.

I was curious which O/R persistency mapping tools are availlable, since I've
used hibernate for Java and it seemed to do the trick quite well in simple
applications. I've found a few open source O/R mapping solutions for
dotnet, but they did not seem very mature to me yet (Sooda, NHibernate,
Gentle, ...), and I don't want to risk having to redo the entire data layer
of the application because of third party instabilities.

I'm curious to know your experiences with o/r mapping in .NET, or if you
know of a website that compares different o/r mapping frameworks for .net.

Thanks in advance,

Guy Mahieu

 

[W.G. Ryan eMVP]

www.deklarit.com has a product that's nothing short of amazing. It does a
lot more than ORM but it certainly does handle that and does it well.

Frans Bouma has a product called LLBLGenPro that's a great product as well.

They both have a decent learning curve but the time spent learning it will
save you hours in the long run. I've used Deklarit quite a bit and couldn't
speak better of it, however I have quite a few friends that live and die by
LLBLGenPro - I don't think you'll be disappointed with either of them.