I'm starting with the Azure platform and I was testing a web api in Asp.Net with EF6 and MySql, however when I upload the application to the Azure server and try to call a service that queries my database, it returns a page from MySql connector error. Can someone tell me which version is available from Microsoft and can I install a newer version in my Azure account?
In my application I use EF6 and the MySql connector is 6.9.
Thank you very much for your attention.
The Azure cloud provider does not have pre-defined connector configurations.
Every connector you need to use, you should upload along with your web project.
That is, if you need a MySQL Connector, just ship it to your web project via NuGet . Since you are using EntityFramework, follow the necessary connectors:
Install-Package MySql.Data
Install-Package MySql.Data.Entity
So you do not depend on any pre-setting environment. You get the connector you need, the version you need, and everything works as planned.