About MySql Connector/NET

Well, I recently came across about 'MySQL Connector', thought to share this one also as my second technical blog. Basically i am in .Net technology now, probably many of my articles will be related to this only.

Let come to our today topic :

Generally the connector enables us to easily communicate between front end languages and back end data bases. For .net technologies we know it has Microsoft's own  connector procedures ADO.Net which can be act as a interface between .net (C#,VB.Net...etc) and its own data base SQL server. Here we don't bother about any additional drivers installation. Most common all .net projects are having SQL Server as data base. Not all, some .Net applications are communicating to

Oracle and MySQL also. In this kind of heterogeneous communication it needs an interface/driver to communicate front end languages to back end data base.  Assuming MySQL has a back end, it needs driver/connector called MySQL Connector to communicate. As MySQL connector here talking as a interface to .Net framework it used to call MySQL Connector/Net. And this connector/NET is fully managed ADO.Net driver which was written in C# only.

 

Recently i was working one application where front end is C#.Net and back end is MySQL.

When i was debugging the application i was getting errors as its unable to retrieve some data from data base , Infact there was no communication to data base. As i am a typical .net guy with traditional ADO.Net and SQL Server programmer, did not think about any drivers or interface. 

After couple of hours research finally came to know MySQL Connector has to be installed.

And versions information and all other relative information can be found at

http://dev.mysql.com/doc/refman/5.0/en/connector-net.html

Have fun.

Thanks,

Ravikiran