MySQL very much does support Stored Procedures! They were introduced in Version 5 along with some other nifty features.
In any case, there is no "easy" way to do this as you can not directly import a MS SQL database into MySQL because they both implement ANSI 92 differently. Your C# code should be find, albeit you will have to change your database providers and such.
Also, you dont use exec to call a stored procedure from MySql, you have to use CALL storedProc('param') or CALL storedProc()
If you have your database queries in one class file and your data access methods in another class file, this is a simple conversion but if all of your queries and such are spread out through your code though, this will take a while to convert over.
hth.
================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
Conversion from C#/SQL Server 2005 to C#/MySQL
