We are about to start development of a web application in MVC3 Razor. We are looking for an ORM that has following aspects:
- If you baffled or puzzled in a scenario you can easy to find a solution or consult
- Easy to manage updates and maintain changes (The changeset and features requirement will be fluent so we would have to be cautious about the alteration and addition in the database. This would be most in precedence)
- Well (Briefed, Easy and Updated) Documented so timely we can learn, apply improvements and the quirks.
- LINQ support
- .NET 4 Support
After this checklist, I started digging. I have seen people are not comfortable with Entity Framework
as compare to NHibernate
because it has a history and Entity Framework
is still developing. But, most of the questions here are asked a while ago and I am assuming there are many improvement done in the contemporary version.
There are ORM Adapters that works with both EF
and NHibernate
. Rather to use EF
or NHibernate
there are some good ORM Adapters which LLBLGEN
and nHydrate
. Hypothetically, both are as good as eachother. LLBLGEN
is more in discussion than nHydrate
.
I would like your opinions of
LLBLGEN
andnHydrate
if you are using one of them and tried the other. Why the one you are using is better than the other?
P.S: If there is something better than both of them based on my checklist please suggest in comments and if it is already suggested in comments praise it by voting it up.
Thanks.