.Net Framework with Other database system

Question

User1039234974 posted

Hello colleagues

I would like to know

if we use the following database systems in .Net Framework development (ASP.Net Web App, MVC, API) ?

1. MySQL
2. PostgreSQL
3. MariaDB

Are these database system compatible with .Net Framework development, like SQL Sever?

and are they supporting Entity Framework features ?

I want to see some references.

Thanks

Answer 1

User-821857111 posted

There are providers for all three database systems that you mentioned. For more information on available providers, check the docs: https://docs.microsoft.com/en-us/ef/core/providers/?tabs=dotnet-core-cli

Answer 2

User1039234974 posted

Thanks for reply: @Mikesdotnetting

Thanks for link ref:

According to your link, EF core support many database providers including providers that I mentioned.

But I am using EF6. EF6 support less database providers , I think. refering to below link.

https://docs.microsoft.com/en-us/ef/ef6/fundamentals/providers/

Answer 3

User197322208 posted

Entity Framework is compatible with many Databases.

Now, there are 2 flavors: EF 6 ( .NET Framework ) and EF Core . I do not knw what you use - but I advise EF Core. 

You can find here the provider list: https://docs.microsoft.com/en-us/ef/core/providers/?tabs=dotnet-core-cli

What  I suggest is to have  a DataAccessLayer project that takes care of the data  . And handles the small differences in syntax.

Answer 4

User-821857111 posted

It's always worth mentioning the version you want help with. New applications should use .NET Core.