locked
MySQL integration with ASP.NET4...... RRS feed

  • 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.

    Sunday, September 25, 2011 2:18 AM

Answers

  • 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




    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, September 25, 2011 4:00 AM

All replies

  • 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




    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Sunday, September 25, 2011 4:00 AM
  • 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.

    Saturday, October 8, 2011 2:57 PM