.NET and MySQL: Which Connector to use?

Posts: 1 · Posted: Sat Feb 18, 2006 4:47 pm

Hey all...

It looks like MySql Connector/ODBC 3.51 is installed on our servers as the MySql Database provider. I was wondering if MySQL Connector/Net (provides .NET specific object architecture) is also installed?

Thanks!

Posts: 1029 · Posted: Fri Feb 24, 2006 12:29 am

Even if it is you don't want to use it. It's far from stable and has, what I consider to be, necessary functionality that is currenlty disfuctional. Like CommandBehavior.CloseConnection Wink

Posts: 2 · Posted: Sat Mar 18, 2006 9:52 am

Josh wrote:

Even if it is you don't want to use it. It's far from stable and has, what I consider to be, necessary functionality that is currenlty disfuctional. Like CommandBehavior.CloseConnection Wink

Just thought I'd better mention that this functionality is in the current version (1.0.7). Besides, if you want to use things like stored procedures, you have no choice but to use the .NET connetor as the ODBC one does not support them...as of yet anyway (I believe it came out before MySql 5).
Yes the .NET connector seems to require read privileges on the mysql.proc table but see here http://forums.mysql.com/read.php?98,41655,70310 for a solution.

I'd say use the .NET connector. When a new version comes up, simply drop it in.

Posts: 3 · Posted: Sun May 21, 2006 9:48 pm

Hello,

This is probably a stupid quesiton, where can I find examples of how to use the .NET connector?

Thanks,
Gypsy

Posts: 46 · Posted: Tue May 23, 2006 3:14 am

There are some links to training, help and support on this page:
http://dev.mysql.com/downloads/connector/net/1.0.html