Menu
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?
585
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”.
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.
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 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.
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).
134
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
