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.

  • NotSupportedException when inserting with Dapper
  • Calculate in a table with different cells - SQL Server / T-SQL
  • MVC4: UserIsInRole - Unable to connect to SQL Server database
  • Using “GO” within a transaction
  • How should i work in this scenario . Should I use Trigger or Leave on User to manage
  • How to join blank table
  • 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.