Challenges selecting Object Relational Mapping (ORM) tools

[daljitsb]

Environment:

New Configurable Web Application/Product development
Server: Windows
.Net C # 2008
Database: It is going to be Database agnostics. Planning to be used initially with SQL Server 2005/2008 ans Oracle 10g/11g.

We have already explored and have shortlisted few Object Relational Mapping (ORM) tools including LINQ

Question:
What can be the challenges, issues, considerations that you can think of and any possible advice to handle that?

Few Challenges we are aware:

Missing UniqueIdentifier datatype in Oracle (options; GUID, ID/counter table, trigger, Stored procedure)

Datatype mapping

Image data handling

performance/metrics

low flexibility

etc...


Please advice. Thanks

[hrishy]

Hi

If you are .Net 2008 then definately LINQ you know right LINQ is used extensively in Microsoft CRM Dynamics which is a huge product.

You might just be interested in

http://channel9.msdn.com/Showpost.aspx?postid=202138

regards
Hrishy

[daljitsb]

thanks hrishy.

looking for more info from experienced folks..