Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Entity framework supported databases

I'm going to make a end-user desktop application, so I need a relative small database, such as Firebird or SqlLite. Does the Entity Framework 4 support other databases than SQL Server?

like image 585
Karsten Avatar asked Feb 04 '10 09:02

Karsten


People also ask

Does MySQL support Entity Framework?

MySQL Connector/NET is compatible with multiple versions of Entity Framework Core. For specific compatibility information, see Table 7.2, “Connector/NET Versions and Entity Framework Core Support”.

Can I use Entity Framework with PostgreSQL?

To use the Npgsql EF Core provider, add a dependency on Npgsql. EntityFrameworkCore. PostgreSQL . You can follow the instructions in the general EF Core Getting Started docs.

Does Entity Framework 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.

What is database providers in Entity Framework?

The database provider is a layer in the EF core architecture that's responsible for the communication between Entity Framework Core and the database. It's a plugable architecture which means we can support all kinds of databases. The first database provider we're going to look at is SQLite.


1 Answers

ADO.NET Data Providers on MSDN lists several third party data providers for ADO.NET. Firebird and SQLite both look like what you are after, and both include Entity Framework 3.5 support (though I can't see any mention of EF4 support).

like image 134
Richard Szalay Avatar answered Sep 19 '22 00:09

Richard Szalay