MULTILPLE DATABASE SUPPORT USING ENTITYFRAMEWORK

Question

Dear Experts,

 

Presently we are having an application(Asp.net ,c#) which is using sqlserver as backend.

Now we want to migrate to another database (Eg: MYSQl,Oracle or someother).

Is it possible to build application which supports multidatabase using EntityFrameWork.

I Don't want the exisiting code to be changed , when i switch to other databases.

Please , give your valuable suggestions.

 

 

 

 

Answer 1

On 1/16/2012 4:57 AM, GopiKrsna wrote:

> Dear Experts,

>

> Presently we are having an application(Asp.net ,c#) which is using

> sqlserver as backend.

>

> Now we want to migrate to another database (Eg: MYSQl,Oracle or someother).

 

EF supports other database providers like MsSQL and Oracle

>

> Is it possible to build application which supports multidatabase using

> EntityFrameWork.

>

> I Don't want the exisiting code to be changed , when i switch to other

> databases.

 

Then your existing code should be using Data Transfer Objects, which an

abstraction away from the underlying ORM.  Layers above a Data Access

Layer will be unaffected by a ORM change or database change in the DAL,

because of the DTO usage.

 

<http://en.wikipedia.org/wiki/Data_Transfer_Object>

 

Answer 2

 

Thanks!