Entity Framework vendors for different databases are shown below.

.net database entity-framework orm provider

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

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

PostgreSQL

Oracle

DB2

Sybase

Informix

Firebird

Provider Wrappers

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

SQLite

PostgreSQL

Oracle

Microsoft SQL Server Analysis Services (SSAS)

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

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Popular Answer

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.

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

Related Questions

Entity Framework options to map list of strings or list of int (List<string>)

I want to store an object that contains a List of primitives using EF....public class MyObject { public int Id {get;set;} public virtual IList<int> Numbers {get;set;} } ...I know that ...EF cannot store... this, but I'd like to know possible solutions to solve this problem....The 2 Solutions I can think of are:...1....Create a Dummy object....
entity-framework list mapping orm
asked by Bernhard Kircher

No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider

I'm trying to use Entity Framework with MySQL and I get the above error. I have the latest MySQL connector installed....The full error reads:...No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider. Make sure the provider is registered in the 'entityFramework' section of the application config file. ...However, I can't fi...
entity-framework mysql
asked by Matt Burland

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'

After downloading the EF6 by nuget and try to run my project, it returns the following error:...No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See ...http://go.microsoft.com/fwlink/?LinkId=2...
entity-framework
asked by Fernando Vellozo

No Entity Framework provider found for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client'

After installing Entity Framework 6.0.1, I keep getting an error ...MAXModel.ssdl(2,2) : error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'Oracle.ManagedDataAccess.Client'. Make sure the provider is registered in the 'entityFramework' section of the application config file. See http://go.microsoft.com/fwl...
.net asp.net-mvc-4 c# entity-framework oracle
asked by Robotron

No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'.

We are using EntityFramework 6 with Code First. We have a console app that has no reference to EntityFramework but reads the connection string from its App.config. It calls the DatabaseInitializationUtilities assembly passing the connection string as a parameter. ...DatabaseInitializationUtilities has the reference to EF6 (EntityFramework and Ent...
.net asp.net c# entity-framework-6 sql-server
asked by Dewey

Oracle ODP.Net With Entity Framework 6 - Entity framework database compatible provider could not be found

I am trying to build an MVC 5 Web application with Entity Framework 6 that works on Oracle Database , am trying to use ODAC 12c Release 3 which includes support for Entity Framework 6 Code First and Code First Migrations; NuGet, .NET Framework 4.5.2; and ODP.NET, Managed Driver XML DB. As per ...http://www.oracle.com/technetwork/topics/dotnet/whats...
.net ado.net-entity-data-model entity-framework odac oracle
asked by Wasef Anabtawi

Entity Framework 6 / Firebird database provider compatibility issue in Visual Studio 2013 Prof

I'm using Visual Studio 2013 Professional and .Net 4.5 on Windows 7-x64. I have Firebird 2.5.4-x64 installed....I know that others are able to use Firebird with Entity Framework 6, and I figured out several issues on my own by reading lots of blogs and stackoverflow posts. But I've tried everything I can think of and I am totally stuck. I figure...
entity-framework-6 firebird
asked by Sherri M

Entity Framework 6.1.3 and SQL Server CE 4.0 - No Entity Framework provider found

PROBLEM: I had a website that was working with my local dev machine (VS2013, EF6.1.3, SQl Server CE 4.0, EF Tools installed). I maintain the website using a git repo locally and in VS OnLine....I am at a different (temporary) location with a new machine. I fetched the website from my git repo down to this new machine. All seemed to work OK (coul...
ef-database-first entity-framework-6 git sql-server-ce-4
asked by RRRSR

How can I create abstract layers between different ORMs (entity framework and Dapper)?

I want to create abstract layer between entity framework and Dapper.In runtime i can choose either entity framework or Dapper or i will both of them also. I know that i can use interface...public IORM{ Save(); Delete(); //other ORM functions } public EntityFramework : IORM{ public Save(){ SaveChanges(); } public Delete(...
abstraction asp.net-core-2.0 c# dapper entity-framework
asked by ManirajSS

Using Entity Framework with Multiple Databases and Providers in the Same Project (SQL Server and MySql)

Background:...I have an application (both web forms and console) that easily accesses multiple SQL Server databases using Entity Framework code first with no problems. I can switch back and forth between contexts with no errors. Now I'm trying to add in a new MySql database (different provider), but if I switch from one context to another, I get th...
.net c# entity-framework entity-framework-6 mysql-connector
asked by Mike

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

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