.net - A list of Entity Framework providers for various databases

Question

Which providers are there and your experience using them

I would like to know about all possible native .NET Framework Entity Framework providers that are out there as well as their limitations compared to the default LINQ2Entities (from MS for MS SQL). If there are more for the same database even better. Tell me and I'll be updating this post with this list.

Feel free to add additional providers directly into this post or provide an answer and others (including me) will add it to the list.

Entity Framework 1

Microsoft SQL Server Standard/Enterprise/Express

• Linq 2 Entities - Microsoft SQL Server connector
• DataDirect ADO.NET Data Providers

Microsoft SQL Server CE (Compact Edition)

• Any provider?

MySQL

• MySQL Connector (since version 6.0) - I've read about issues when using Skip(), Take() and Sort() in the same expression tree - everyone welcome to input their experience/knowledge regarding this.

  Note: MySQL Connector/NET Visual Studio Integration is not supported in the Express Editions of Visual Studio, meaning you won't be able to view MySQL databases in the Database explorer window or add a MySQL data source via Visual Studio wizard dialog boxes. Some users may find that this limits their ability to use Entity Framework and MySQL within Visual Studio Express).

• Devart dotConnect for MySQL - similar issues to MySql's connector as I've read and both try to blame MS for it [these issues are supposed to be solved]

SQLite

• Devart dotConnect for SQLite
• System.Data.SQLite

PostgreSQL

• Devart dotConnect for PostgreSQL
• Npgsql

Oracle

• Devart dotConnect for Oracle
• Sample Entity Framework Provider for Oracle - community effort project
• DataDirect ADO.NET Data Providers

DB2

• IBM Data Server Provider has EF support. Here are some limitations.
• DataDirect ADO.NET Data Providers

Sybase

• Sybase iAnywhere
• DataDirect ADO.NET Data Providers

Informix

• IBM Data Server Provider supports Informix

Firebird

• ADO.NET Data Provider with EF support

Provider Wrappers

• Tracing and Caching Providers for EF

Entity Framework 4 (beta)

Microsoft SQL Server

• Microsoft's Linq to Entities 4 - shipped with .net 4.0 and Visual Studio 2010; so far the only provider for EF4

MySQL

• MySQL .NET connector, mostly functional but pending issues with CreateDatabase and DatabaseExists methods (v6.3.5)
• Devart dotConnect for MySQL

SQLite

• Devart dotConnect for SQLite

PostgreSQL

• Devart dotConnect for PostgreSQL

Oracle

• Devart dotConnect for Oracle

Microsoft SQL Server Analysis Services (SSAS)

• SSAS Entity Framework Provider

Answer 1

DB2 will work, but if you want to use some of the out-of-the-box .NET features that we all take for granted (think membership and role providers), you will have quite a bit of work on your hands. DB2 doesn't really do well with Stored Procedures, so you are also looking at a lot of parameterized inline SQL.

I also had some performance issues with the provider from IBM. There is another provider available from a company called DataDirect. It looks to be more performant, but it will cost you. For something like an external facing website, where speed is important, the cost probably will not be an issue.

I am sure that DB2 is a great system if you are building on another platform, but it wasn’t really designed to play nice with .NET. Unless you are already married to DB2, I would look elsewhere.