Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What database systems are fully supported by Entity Framework 6 and/or 7?

Which database systems (relational or NoSql) are supported by Entity Framework 6 and/or 7?

like image 249
Jonathan Kittell Avatar asked May 24 '15 18:05

Jonathan Kittell


People also ask

Does EF core support MySQL?

MySql is the most popular Entity Framework Core provider for MySQL compatible databases. It supports EF Core 3.1 (and lower) and uses MySqlConnector for high-performance database server communication. The following versions of MySqlConnector, EF Core, .

Does Entity Framework work with NoSQL?

When you use NoSQL databases for your infrastructure data tier, you typically do not use an ORM like Entity Framework Core. Instead you use the API provided by the NoSQL engine, such as Azure Cosmos DB, MongoDB, Cassandra, RavenDB, CouchDB, or Azure Storage Tables.

Is Entity Framework good for large database?

There are plenty of ways to improve performace of entity framrework with large dataset. It will resolve you major pain area and the section where you cannot see the performance improvement use classic DB stored procedure and call them with entity framework.


1 Answers

The Entity Framework documentation has a long list (right hand side) of 3rd party providers. The ones listed today are:

  • MySQL Connector/NET
  • System.Data.SQLite
  • Oracle Data Provider for .NET
  • VistaDB
  • Devart
  • cdata
  • OpenLink Software
  • IBM
  • Sybase SQL Anywhere
  • Sybase Adaptive Server Enterprise
  • Phoenix Software Solutions
  • Synergex
  • Firebird
  • Npgsql
  • NuoDB
  • Ritmo for IBM i (DB2)

EF7 is harder to find info for, but here are some links that may help:

http://blogs.msdn.com/b/adonet/archive/2014/05/19/ef7-new-platforms-new-data-stores.aspx http://www.infoworld.com/article/2885466/application-development/entity-framework-7-providing-support-for-new-platforms-and-new-data-stores.html

like image 152
Martin Noreke Avatar answered Sep 30 '22 04:09

Martin Noreke