Skip to content

Metadata from SqlCommandProvider #188

@jackfoxy

Description

@jackfoxy

Given an instantiated type

type MySqlType = SqlCommandProvider<...>

use cmd = new TestFirstResultSet(conn)
  1. new method
DescribeFirstResult(params : string option, browseInformationMode : BrowseInformationMode)
    BrowseInformationMode.NoInfo 0
    BrowseInformationMode.ForBrowse 1
    BrowseInformationMode.ForCursor 2
  1. new method ShowPlan() returns XML:
SET SHOWPLAN_XML ON;
    GO
<sql from type>
  1. new property value TypeName (returns "MySqlType" in this example)

  2. Might as well cover sys.sp_describe_undeclared_parameters too. (I have no immediate need, but it would cover all the metadata I can think of.)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions