Wednesday, March 5, 2008

MySQLDirect .NET Data Provider - From CoreLab (CoreLab.MySql)

____________________________________________________________________

MySQLDirect .NET Data Provider - From CoreLab (CoreLab.MySql)

____________________________________________________________________

MySQLDirect .NET is data provider to direct access to MySQL database server for the Microsoft .NET Framework and .NET Compact Framework. It is completely based on ActiveX Data Objects for the .NET Framework (ADO.NET) technology. ADO.NET provides a rich set of components for creating distributed, data-sharing applications. It is an integral part of the .NET Framework, providing access to relational data, XML, and application data.

MySQLDirect .NET data provider can be used in the same way as the SQL Server .NET or the OLE DB .NET Data Provider. Data provider can access MySQL server either using native MySQL network protocol directly or through MySQL client library. It allows to create lightweight and fast applications working with MySQL.

Using C#

uusing CoreLab.MySql; 
... 
MySqlConnection oMySqlConn = new MySqlConnection(); 
oMySqlConn.ConnectionString = 
    "User ID=myUsername;" + 
    "Password=myPassword;" + 
    "Host=localhost;" + 
    "Port=3306;" + 
    "Database=myDatabaseName;" + 
    "Direct=true;" + 
    "Protocol=TCP;" + 
    "Compress=false;" + 
    "Pooling=true;" + 
    "Min Pool Size=0;" + 
    "Max Pool Size=100;" + 
    "Connection Lifetime=0"; 
oMySqlConn.Open();


____________________________________________________________________
Note:If You have need demo then contact with me.Post your request as a comment.
____________________________________________________________________

No comments: