Description
The current MySQL provider does not implement the ISqlProvider.GetSprocs
function.
The implementation should use the MySQL metadata capabilities to establish the names and parameters of stored procedures. (Probably using INFORMATION_SCHEMA
, or maybe the Connection.GetSchema
can tell you about sprocs)
The more tricky bit is working out what columns the sproc returns. We can only really support simple procedures that don't return multiple or different recordsets depending on branching logic. OUT parameters are currently not supported so those ones should be ignored.
The SQL Server implementation (which is somewhat of a mess currently) executes the proc with some default parameters along with ``CommandBehaviour.SchemaOnly` to establish this information. I don't know the capabilities of MySQL, perhaps there is a nicer way to achieve this.
Once you are able to return a list of sproc data, the rest should just all magically work!