What ORM frameworks for .NET and Oracle Do You Like Best?
+6
A:
NHibernate works best and is one of the most mature frameworks with a lot of real-world projects using it with Oracle.
Manu
2009-10-16 08:26:58
I should add though that I usually need to modify or extend it a bit to suit my needs.
Vilx-
2009-10-16 08:37:49
it's open source
Manu
2009-10-16 08:42:36
very well,can provide it all oracle data types and automaticly generate entity classes as like linqtosql?is there a ide for nhibernate?
tobias
2009-10-16 08:44:33
+1
A:
Subsonic is a small but very feature full project which enables you to get up and running with a project very quickly. It also include migrations like Ruby On Rails to keep your database up to date with your domain.
Blounty
2009-10-16 08:36:06
Sunsonic is light weight and pretty powerful for small-medium sized proejcts.
Pino
2009-10-16 09:38:46
A:
Here are a few ORM frameworks that could help you out
I have used NHibernate and been really happy with it, the Xml you need to create gets annoying really quickly, that's why you have Fluent NHibernate and ActiveRecord that create those mapping for you. I have yet to use Fluent NHibernate in my project, but I've created a project using Active Record and was loving it, so easy to use.
Unfortunately I've also tried the Entity Framework which simply just can't handle an Oracle database without buying a 3rd party product for it. I tried out the Sample Entity Framework Provider for Oracle but I didn't get it to work. So my Oracle Entity Framework experiment failed :S
There are a lot of ORM mappers out there, I've just listed a few of them and actually used only 3 of them. I would recommend googling this out and check what the community as saying about the ORM's that you like and maybe a few proof-of-concept projects before making a final decision
armannvg
2009-10-16 09:47:01
A:
very well,nhibernet can provide it all oracle data types and automaticly generate entity classes as like linqtosql?is there an ide for nhibernate?
tobias
2009-10-16 11:16:41