C# mySQL Connection

[ziycon]

I'm developing an application in VS2008 using c# and I had a SQLite database work but want to go with mySQL.

Can anyone point me to the best way to use a mySQL connection with c#, should I use a persistent connection!?

Thanks in advance.

[AfzalKK]

first what you need is MySQL library files. you can find it in here. and it contain the help file where you can search for all syntax of MySQL. If you need any more help ask me.