What ORM would you recommend?

Question

Here's my reqiurements:

1. Supports C#
2. Supports Oracle
3. Supports LINQ
4. Has ability to map business objects to database tables (not necessarily a 1-to-1 mapping)

I know an Oracle Entity Framework provider would support all these, but I've been told that making the custom mappings is not very easy.

What would you suggest?

Answer 1

I'd use nHibernate. The linq support is coming. Not sure if its in their latest build or not but they just released a beta of their next release. It supports the rest of your requirements.

Answer 2

If you want something that has native linq support as well as supporting all the features above, I'd have a look at llblgen pro or there's a new player called Genome.

llblgen pro has been around for a long time and having used it on previous projects would recommend you check it out.

Answer 3

Have not tried myself but you could try: http://devart.com/dotconnect/oracle/

Answer 4

Use ALinq, www.alinq.org

Answer 5

SubSonic. It's free and able to do all the things you've described.

Answer 6

Half a vote for Mindscape Lightspeed - a fine unit-of-work style cross-database ORM that works on Mono. They have some limited LINQ support at the moment with more in field test.