Suggestions for a pluggable database

Question

I am currently working on a software project that uses a SQL Server database to store data. Since there are plans to abandon SQL Server for Oracle, one of the requirements is to create a pluggable database layer.

So my question is the best way to do this?

Answer 1

You have many options. One option is to go with one of the various object relational mapping (ORM) infrastructures. NHibernate is popular, but the Microsoft Entity Framework (in version 4) is also a smart feature, and it integrates better with Linq if that's what interests you.

( ) , - . ORM ; , ORM. , , - ORM. , , , , ORM.

Answer 2

NHibernate . , , .

NHibernate MsSQL, Oracle.

Hibernates (HQL), . linq NHibernate 3 .

, SessionFactory.

. Oracle - Entity Framework: http://thedatafarm.com/blog/data -/ ----/

1: http://nhforge.org/Default.aspx## ##

Answer 3

Entity Framework, , NHibernate, . EF .

Entity , . , Dependency Injection, . ORM. , NHibernate, .

Answer 4

ORM-, NHibernate alexn Telerik OpenAccess ORM. EF Oracle , .

If you want to build the whole DAL from scratch, than using a repository template. Create an interface for the repository and create each repository provider for each db. Here is a discussion.