A list of Entity Framework providers for various databases
- by Robert Koritnik
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
Devart dotConnect for MySQL
SQLite
Devart dotConnect for SQLite
PostgreSQL
Devart dotConnect for PostgreSQL
Oracle
Devart dotConnect for Oracle