CODEWITHSUNDEEP
sql-serveroracle-databaseentity-frameworknhibernateorm
Maxim V. Pavlov
Maxim V. Pavlov

Reputation: 10509

EF vs NHibernate with Oracle

This is not another one of the "holy-war" questions. It is concrete and is absolutely answarable.

Base asumption for this question is that noth NHibernate and Entity Framework 4.3 Code First work well with MS SQL SERVER.

It came to my attention that people are having problems with usign the Entity Framework 4.3 Code First in conjunction with Oracle RDBMS. Several fundamental problems exits and seemless integration is not-yet possible.

It the same true for NHibernate, or will I be able to switch between MS SQL and Oracle Data Providers seemlessly knowing my application works well with either product when I use NHibernate as my ORM framework?

UPDATE: The problems that others had with using the EF with Oracle are derived from the answer to this question. In particular this user's problem hasn't been resolved yet: Oracle ODP.Net and EF CodeFirst - SaveChanges Error

Upvotes: 0

Views: 729

Answers (1)

Diego Mijelshon
Diego Mijelshon

Reputation: 52725

Switching databases is never 100% seamless. NH is more mature and works better across RDBMS's, but the complexity of switching depends on how you use it.

See my answer on Recommendations for supporting both Oracle and SQL Server in the same ASP.NET app with NHibernate

Upvotes: 2

Related Questions