What is best ORM with these requirements [closed]

Question

I'm looking for a good ORM for an upcoming project.

The database will have around 1000 to 1200 tables, and it will be in Both SQL Server and Oracle, which will be used depending of customers enterprise needs. Also a few part of the project will work with WCF services. I want a designer or something like that. Good support of LINQ. Acceptable performance.

I have tried DataObjects.Net but it doesn't have any designer. We can't code all that tables nor use code generator. And I'm not sure if DataObjects.Net supports switching database. Also I'm familiar with EF4 but it can't support both databases together, and switching databases manually(modifying the edmx file) is such a pain in ... for maintenance job.

Thanks in advance.

Edit: Seems OpenAccess and LLBLGEN Pro have designer but I don't have experience with them.

Answer 1

I would still vote for Entity Framework v4 - EF4.

After all:

• you can have multiple EDMX files, no problem - one for SQL Server, one for Oracle

• you could put those into their own class library, and then load or, or the other, or both, if needed, at runtime (e.g. by using the Managed Extensibility Framework or something of your own)

• you can easily target those EDMX files at databases using connection strings - really not hard at all

Answer 2

OpenAccess can also do the job for you. You could use the multiple .rlinq files and assembly-per-database approach as suggested with Entity Framework. The benefit I see for you would be the support you will get from Telerik as there is quite a chance for you to hit a rock or two while developing a solution of such proportions.