I am a novice C-Sharp(C#) programmer. I am working for a student project.
By default MS SQL can be used easily with this language.
But I have a database on MySQL.
Could I use MySQL server to query with C-Sharp(C#) language?
How can I connect MySQL database?
Please help by sharing your knowledge.
MySQL can be used to query C# but first you need to install MySQL connector.Â
A new project has to be created, then add a reference/references to MySQL data.
Add using MySQL data.MySQL client, then add the data that can be retrieved on a MySQL database.
After all this process you would have created a connection and therefore you will be able to use MySQL server to query with C# without a problem.Â
I have tried it and it worked for me and I hope it will work for you, if you follow the steps precisely without missing any of the recommendations in this paper work.
