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.

  • How to report an error from a SQL Server user-defined function
  • How should I go about comparing all rows in a sql table against a “master record” using vb.net?
  • Include an ALL inclusive category using CASE statement
  • SQL Server / PHP / Web Based Admin Tool - What are some phpmyadmin-like tools for SQL Server?
  • Looping SQL statement insert
  • Remove Enums from list if they already exists in database
  • Is this possible? I prefer real life examples!

    What kind of providers did you use?

    2 Solutions collect form web for “The entity framework and database agnostic programming, possibilities?”

    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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.