Last post Aug 07, 2020 08:54 AM by Mikesdotnetting
Aug 07, 2020 02:46 AM|SKKO.mail|LINK
I would like to know
if we use the following database systems in .Net Framework development (ASP.Net Web App, MVC, API) ?
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.
Aug 07, 2020 06:26 AM|Mikesdotnetting|LINK
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
Aug 07, 2020 07:48 AM|SKKO.mail|LINK
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.
Aug 07, 2020 08:40 AM|ignatandrei|LINK
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.
Aug 07, 2020 08:54 AM|Mikesdotnetting|LINK
It's always worth mentioning the version you want help with. New applications should use .NET Core.