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