fsprojects / fsprojects/FSharp.Data.SqlClient

feature request: add parameters and fields description.

Open
#184 0 comments 0 reactions 1 assignee View on GitHub

@ntr is already working on this.

Since Mar 25, 2016.

feature up-for-grabs
Dominant language
F#
Stars
206
Forks
66
PR merge metrics
No merged PRs in 30d

Description

Considering

type MyCommand = SqlCommandProvider<sql, connection>

it would be nice to have

MyCommand.Record.Fields.All : (string * type) list
MyCommand.Record.Fields.field1 : (string * type)
MyCommand.Record.Fields.field2 : (string * type)
// ...
MyCommand.Parameters.All : SqlParameter list // maybe another class is more relevant?
MyCommand.Parameters.param1 : SqlParameter
MyCommand.Parameters.param2 : SqlParameter // maybe another class is more relevant?
// ...

The reason is to help get rid of magic strings and improve static checking of code which still rely on plain System.Data.SqlClient.SqlCommand based on the provided commands.

One reason I have to do that is that I need to strip out the with result sets of my commands to support older versions of SQL Server.

All this would be moot whenever generated types would be landing, but I'm not sure if there is a clear timeframe for this feature.

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.