Well I uninstalled MySQL 4.1.1 from my GNU/Linux box and installed the 5.0.0 alpha version with support for stored procedures. The manual that came with it didn't have any info on how to create stored procedures, but the one on the MySQL site does have it so it didn't take me long to create a proc to do the insert on my test page. The ADO.NET provider from ByteFX has a class named MySqlHelper which is similar to the Microsoft Application blocks SqlHelper class but with only the simplest overloads. Currently it doesn't seem to support passing params to a stored procedure as such, you can only pass a command string so to call a stored procedure the syntax is like:
“CALL usp_MyProc('value', 'value')“
At least it puts most of the SQL code in the database which is better than using a bunch of dynamic sql generated in the .NET code. I'm sure they will be adding overloads to support stored procedures in the future, this is beta code and the database itself is alpha code. It all works well enough to get me motivated in moving forward with MySQL in my new development.