PDA

View Full Version : How to connect to a mysql database in c#?

windstyle
10th October 2007, 19:15
Is there a way to connect to a mysql database without using OLEDB?

Greetz Glenn
DarkTimes
10th October 2007, 20:41
http://dev.mysql.com/tech-resources/articles/dotnet/
Woz
11th October 2007, 07:58
Look at http://www.mygenerationsoftware.com/portal/default.aspx

Its has an ORM code gen. Just point it at the database tables you wwant to interect with and it creates simple to use object wrappers, CRUD based SPs to update the tables. It provides type safe generation of SQL via object properties etc.

It can talk with most DBs and actually allows you to change the database without changing ANY code above the ORM level.
windstyle
11th October 2007, 20:19
thx! dit it with the mysql.data.dll file :)
mcgas001
14th October 2007, 18:24
You know i just managed to do this my self it works ok and ive had no problems :D