connecting to a linux server running myql from a windows .net server, ado.net?

Question

Can I connect to a ubuntu server, that is running mysql using ado.net or do I need a special driver?

Answer 1

You use Connector/NET.

Answer 2

You'll need the MySQL Connector/NET ADO.NET driver.

Once installed, it behaves almost identically to Microsoft's native System.Data.SqlClient. Instead of importing that namespace, use MySQL's:

using MySql.Data.MySqlClient;

...

MySqlConnection DB = new MySqlConnection("SERVER=...");

Basically, just prepend My where you'd use any of the MS SqlClient classes.