Entity Framework vendors for different databases are shown below.

.net database entity-framework orm provider

Question

Which service providers are present, and how have you used them?

I'm interested in learning about the available native.NET Framework Entity Framework providers' capabilities as well as how they stack up against the standard LINQ2Entities (from MS for MS SQL). Better still if there are more for the same database. If you tell me, I'll add this list to the article.

Please feel free to add more providers right into this article, or you may respond with an addition and I'll do the same.

First Entity Framework

Microsoft SQL Server Enterprise/Standard/Express

Windows Server SQL Server CE (Compact Edition)

  • Any providers?

MySQL

  • Connector for MySQL (since version 6.0) - There are problems with utilizingSkip() , Take() and Sort() Everyone is invited to share their experience and expertise about this in the same expression tree.

    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).

  • 85 zzz, 90 zzzzzz, and 94 zzz

SQLite

PostgreSQL

Oracle

DB2

Sybase

Informix

Firebird

Supplier Wraps

Fourth Entity Framework (beta)

Server Microsoft SQL

  • The sole EF4 provider at this time is Microsoft's Linq to Entities 4, which came pre-installed with.net 4.0 and Visual Studio 2010.

MySQL

SQLite

PostgreSQL

Oracle

Analysis Services for Microsoft SQL Server (SSAS)

1
82
5/23/2017 12:00:31 PM

Popular Answer

I doubt DB2 is now compatible with EF 4. If it does, kindly correct me and explain the proper procedure. The DB2 providers will not appear in the Data Source dialogs, at least not for me.

3
4/27/2010 9:20:46 PM


Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow