各种数据库的实体框架提供程序的列表 [英] A list of Entity Framework providers for various databases

问题描述

有哪些提供商以及您使用这些提供商的体验

我想了解所有可能的原生.NET Framework Entity Framework提供者以及它们与默认的 LINQ2Entities （来自MS for MS SQL）相比的限制。如果有更多的同一个数据库更好。

您可以直接在这篇文章中添加其他供应商，或提供答案，其他人（包括我）将会

实体框架1

Microsoft SQL Server Standard / Enterprise / Express

• Linq 2实体 - Microsoft SQL Server连接器


• DataDirect ADO.NET数据提供商

Microsoft SQL Server CE（精简版）

• li>
  

MySQL

• MySQL Connector （从6.0版开始） - 我已阅读有关问题当使用 Skip（）， Take（）和 Sort（）

  
  

  注意

  strong>：MySQL Connector / .NET Visual Studio中的Express版本不支持Visual Studio集成，这意味着您将无法在数据库浏览器窗口中查看MySQL数据库，或通过Visual Studio向导对话框添加MySQL数据源。某些用户可能会发现这限制了他们在Visual Studio Express中使用Entity Framework和MySQL的能力。

  
  




• Devart dotConnect for MySQL - 类似于MySql的连接器，我已阅读并且都试图将它归咎于MS [这些问题应该是解决]

  
  

b

• Devart dotConnect for SQLite


• System.Data.SQLite

PostgreSQL

• Devard dotConnect for PostgreSQL


• Npgsql

Oracle

• Devart dotConnect for Oracle


• 示例实体框架提供程序Oracle - 社区努力项目


• DataDirect ADO.NET数据提供者

DB2

• IBM数据服务器提供商具有EF支持。以下是一些限制< a>。


• DataDirect ADO.NET数据提供商

Sybase

• Sybase iAnywhere


• DataDirect ADO.NET数据提供商

Informix

• 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

Firebird

• ADO.NET数据提供者与EF支持

提供程序包装器

• EF的追踪和快取供应商

实体框架4（ beta ）

Microsoft SQL Server

• Microsoft的Linq to Entities 4 - 随.net 4.0和Visual Studio 2010一起提供;目前为EF4的唯一提供者

MySQL

• MySQL .NET连接器，主要功能（v6.3.5）


• Devart dotConnect for MySQL

SQLite

• Devart dotConnect for SQLite

PostgreSQL

• Devart dotConnect for PostgreSQL

Oracle

• Devart dotConnect for Oracle

SQL Server分析服务（SSAS）

• SSAS Entity Framework Provider

解决方案

不认为DB2使用EF 4。如果是，有人请纠正我，告诉我它的做法。我不能让DB2提供程序显示在数据源对话框中。

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

解决方案

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屋！