One of the features introduced in Entity Framework is being database independent. Which mean each database provider can support Entity Framework by implementing its provider.
This feature allows you build applications independent from the underplaying database provider. In this post I’m going to show how to build an application that support multiple databases using same conceptual model made by Entity Framework.
Entity Framework providers
Entity Framework is database independent. Each database provider could have its own Entity Framework provider. Currently there are several database provider who support the current version of Entity Framework that is released with .Net 3.5 SP1.
A list of Entity Framework providers can be found here.
Entity Framework multiple database support sample
In this post, I am going to demonstrate a sample application (based on northwind database) that is going to support both SQL Server database engine and MySQL database engine.