Having trouble getting my Xamarin project to open a connection to MySQL. In a basic console app using the full .net framework the code runs fine, but in my xamarin project running on .net standard 2.0 it fails. Any suggestions on how to handle this?

From what I have read .net standard doesn't work with the connector and the best way around it is to use a web api, is that true?

Any help is greatly appreciated I am fairly new to Xamarin.