Way back in February I gave a webinar on using our Visual Studio integration product with MySQL. At the time, our code did not integrate very well with the TableAdapter wizard. To be precise, you really couldn't use stored procedures with a table adapter at all. During the broadcast, someone asked me about using stored procedures and I told him that I would blog about it once I got it working. Well, here we are.
Actually, we've had it working for a couple of weeks now but I'm just now getting to the blog post. You know how it is. There were several problems at play here but the biggest issues were the fact that we needed to provide an enumerator object for columns that would be returned by a stored procedure. The second issue was needing to use the DbProviderSpecificTypeProperty attribute on our provider specific type property on the parameter class. Let's look at each one of these in more …
[Read more]