What's the best way to install MySql.Data on azure app service?
We have a PHP application that requires some powershell scripts to be run in the background, these scripts must connect to the MySQL database (Azure MySql). The current code requires the "MySql.Data.dll" to do so. This is not something we have.
Add-Type -Path "D:\home\data\bin\MySQL.Data\v4.5.2\MySql.Data.dll"
This is a tool we've recently inherited and their current solution is to install the MySQL .NET Connector on a windows machine and upload the binary contents.
Personally would like a more maintainable method of doing so.
If you require more information please do ask.
Many thanks
Albeit not the best solution the current most optimal way we could decide is to continue with uploading the contents of the downloaded tool as suggested by this article here:
https://poszytek.eu/en/microsoft-en/azure-en/references-in-azure-functions-custom-dlls-how-to/