MySQL integration with ASP.NET4......

Question

User-809550105 posted

Hi,

Currently i am using MS-SQL Express.....

Now my client asked me to use MySQL instead of MS-SQL.

Can anyone help me how to connect and integration with My-SQL and i

have no knowledge about My-SQL........

Thank You.

Answer 1

User1269925535 posted

hi...

i was in siution like you befor...

i have some suggestion for you:

1-try to ask your client to use MS-SQL

2-if he did not accecpt :

use : oledb class to work with MY-SQL

http://www.15seconds.com/issue/050210.htm

http://www.codeproject.com/KB/database/MySQLCsharp.aspx

and this link:

http://www.dotnetheaven.com/Forums/ShowMessages.aspx?ThreadID=84864
http://longhorncorner.com/forums/ShowMessages.aspx?ThreadID=84864
http://blog.stevienova.com/2008/01/16/net-fastest-way-to-load-text-file-to-sql-sqlbulkcopy/

http://stackoverflow.com/questions/103167/what-is-the-difference-between-ole-db-and-odbc-data-sources
http://codicesoftware.blogspot.com/2008/04/fastest-way-to-insert-100k-registers.html

Answer 2

User-1842273979 posted

I am working on project now and  using MySQL and ASP.NET 4.0. And it seems to be ok. .NET connector inegrated successfully. U get  menu item (like earth) on the right upper conner on server explorer window when you installed .net connector for MySQL. It is handy to create connection strings and other config as well. You can find other information in "help" that is installed along with .net connector.