The entity framework and database agnostic programming, possibilities?

We want to use the Entity Framework (.NET 4.0) to开发者_Go百科 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?

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.

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