各种数据库的实体框架提供程序列表 [英] A list of Entity Framework providers for various databases
问题描述
哪些提供者在使用它们的使用
我想知道所有可能的本地.NET Framework实体框架提供程序与默认的LINQ2Entities （从MS MS MS）相比，它们的限制以及它们的限制。如果同一数据库更多，更好。告诉我，我将使用这个列表更新这篇文章。
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.
Microsoft SQL Server标准版/企业版/ Express
- Linq 2实体 - Microsoft SQL Server连接器
- DataDirect ADO.NET数据提供者
- Linq 2 Entities - Microsoft SQL Server connector
- DataDirect ADO.NET Data Providers
Microsoft SQL Server CE（精简版）
- 任何提供者？ li>
- Any provider?
MySQL
-
MySQL连接器（自版本6.0） - 我已经阅读了有关问题当使用
Skip（），Take（）和Sort（）在同一个表达式树 - 大家欢迎输入他们的经验/知识。
MySQL Connector (since version 6.0) - I've read about issues when using
Skip(),Take()andSort()in the same expression tree - everyone welcome to input their experience/knowledge regarding this.
注意：MySQL连接器/ Visual Studio集成在Visual Studio的Express Edition中不受支持，这意味着您将无法在数据库资源管理器窗口中查看MySQL数据库或通过Visual Studio向导对话框添加MySQL数据源。一些用户可能会发现这限制了他们在Visual Studio Express中使用Entity Framework和MySQL的能力）。
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 - MySql连接器的类似问题，如我所看到的并且都试图怪责MS [这些问题应该是解决]
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 。以下是一些限制。
- DataDirect ADO.NET数据提供商
- 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 < a href =http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.wn.doc/doc/c0051507.html = nofollow noreferrer>支持Informix
- IBM Data Server Provider supports Informix
Firebird
- ADO.NET Data Provider with EF support
提供者包装
- Tracing and Caching Providers for EF
Microsoft SQL Server
- Microsoft的Linq to Entities 4 - 附带.net 4.0和Visual Studio 2010;到目前为止，唯一的EF4提供者
MySQL
- MySQL .NET连接器，主要功能但是与CreateDatabase和DatabaseExists方法（v6.3.5）挂起的问题
- Devart dotConnect for 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
推荐答案
我不认为DB2与EF 4一起工作。如果有的话，有人请纠正我，告诉我怎么做。我不能让DB2提供程序显示在数据源对话框中。
I don't think DB2 works with EF 4 yet. If it does, someone please correct me and tell me how its done. I cannot get the DB2 providers to show up in the Data Source dialogs.
这篇关于各种数据库的实体框架提供程序列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
