Connect C# to mySQL Example

This example requires MySQL.Data.MySqlClient and System.Data.SqlClient to insert data into a MySQL database. Originally, I had an error during execution: IO.FileNotFoundException in MySql.Data.dll: Can’t load System.Security.Permissions. To fix the issue. I had to go to SOLUTION EXPLORER and right-click the project name and go to MANAGE NUGET PACKAGE. From there, I had to go to BROWSE (Center of the screen) and look for MYSQL.DATA. Once found, I had to install MYSQL.DATA (This version was 8.0.18). Once installed that fixed problem.

Leave a Reply

Your email address will not be published. Required fields are marked *