what is the best (or more suitable) ORM solution between .NET and Oracle

[Lyu KingT]

i am getting boring with writing SQL scripts in .NET codes, so what is the best (or more suitable) ORM solution between .NET and Oracle.

or is there some primary resources i can read and learn.
thanks.

[Sfreak]

Liu KingT,

There are many ORM frameworks available. I ve been testing them for a while. There are many aspects that you may evaluate.
1 - If you are intending to develop your applicatiion running on many databases, the best option is to use NHibernate, since Entity Framework Code Rush (or Code Only) is on CTP. The main problem of native NHibernate is to manage the XML files. For this issue we have some ways to make it easier using for example ActiveRecord, CodeSmith, MyGeneration etc.
2 - If you are intending to use just one database a good solution is to use Entity Framework but remember ... it only works fine on VS 2010 its easy to use and maintain the .edmx files.

There are other solutions not listened here but all of them follows one of these examples.

Hope this can help you

Fernando Mello

[Lyu KingT]

hi, Fernando Mello, thanks for your reply.

if i begin to learn one of them, should i just read the documents from their official website(www.nhforge.org or www.msdn.com), or do any references you once have read can help me to use them as quickly as possible.

best wishes.

Lyu

[Sfreak]

Lyu,

Try to start reading the MSDN library. It teaches how to implement a consistent Entity Framework model.

The link follows below:

http://msdn.microsoft.com/en-us/library/bb399572.aspx

Its pretty easy if you get the conception of ORM.

Feel free to contact me if you have further questions.

Fernando Mello

[Lyu KingT]

hi Fernando Mello,
thanks.

[Sfreak]

Lyu,

You are welcome


Fernando Mello