my sql database connection from c#.net

[bitelindia]

I want to use mysql database from .net. c# lanugage.

 

Microsoftt have provided for sql server and oracle, .net data provider provider.

 

ODBC data provider for .net is slow.

 

I have tried third party .NET data probider BYTEFX from source forge given at mysql site. But it is giving connection problem :-

 

Pinvoke meta data format error.

 

I am in search for some other .net data provider for mysql

 

If some one have tried for BYTEFX .net provider kindly help.

 

or Give me the information for some other third party my sql .net data provider

 

Thanks & Regards,

G.S.Batra

[iebidan]

well, I don't know how slow it's for you, but for me works great, I made a query on 3 tables (JOINS) with over 600,000 rows and got the result in 10 secs or less and I'm using SqlClient for .NET, are you using it too?, here is a simple example on how to do it

 

string s_Connect = "Data Source=SERVERNAME;User Id=USERNAME; pwd=PASSWORD; Initial Catalog=DATABASE";
SqlConnection oConn = new SqlConnection(s_Connect);
SqlDataAdapter oDAdap = new SqlDataAdapter(qry,oConn);
DataSet dsPpto = new DataSet();
oConn.Open();
oDAdap.Fill(dsPpto,"HEADER");		
DataView dv=new DataView(dsPpto.Tables["HEADER"]);

 

about third party drivers, I've no idea, but try this kind of connection, you don't need to declare any ODBC in the control panel, it's an ODBC less connection ;)

[Derek Stone]

He's dealing with MySQL not Microsoft SQL Server, iebidan.

[iebidan]

oh, yeah... skipped that part of MySQL... my mistake