The entity framework and database agnostic programming, possibilities?

views:

110

answers:

The entity framework and database agnostic programming, possibilities?

We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too.

It should be easy to switch the db vendor by some setting in a config file.

Is this possible? I prefer real life examples!

What kind of providers did you use?

+3 A:

NHibernate?

But in the real world these plans usually result in an application that does not use any of the strong points of any of the database.

Robert Merkwürdigeliebe 2010-04-22 14:58:06

agreed ... and they must pander to the least-common-denominator of all the databases supported, which means the customers may as well just use the cheapest DB available, which means they don't need it to be DB-agnostic after all :)

Jeffrey Kemp 2010-04-23 06:04:37

agreed... the weakest link. It's hard enough to create an app that works well with one database. I thought we left the 'it's just a data dump' attitude behind us.

Robert Merkwürdigeliebe 2010-04-23 06:59:31

Yes, it's possible.
Take a look at our EF Query samples

Devart 2010-04-23 09:07:27

ansaurus

tags:

views:

answers:

The entity framework and database agnostic programming, possibilities?

related questions