Using C# with MySQL Database how to do it?

I'm building application using C# and I want to save my data to MySQL Database.Tool that I use to create database are XAMPP. My problem is when when i trying to create DataSources in C# with new connection there is no .mdf file because I'm using MySQL Database the only file I have is db.opt. When I Test Connection the error is

An attemp to attach an auto-named database for file c:\Program Files\xampp\mysql\data\mycpr\db.opt failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNCshare.

Please show me how can I using MySQL Database with C#. The reason I'm using MySQL Database because the data that i pullout using C# then will publish on the website that I build using php srcipt.



Answer this question

Using C# with MySQL Database how to do it?