Skip to content

MySQL should support stored procedures #31

Closed
@pezipink

Description

@pezipink

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!

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions