fsprojects / fsprojects/FSharp.Data.SqlClient

Metadata from SqlCommandProvider

Open
#188 2 comments 0 reactions 1 assignee View on GitHub

@ntr is already working on this.

Since Mar 25, 2016.

feature
Dominant language
F#
Stars
206
Forks
66
No merged PRs in 30d

Description

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.)

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.