SqlProgrammabilityProvider ResultType

[davidtme]

Description

The SqlProgrammabilityProvider intellisense lists

ResultType: A value that defines structure of result: Records, Tuples, DataTable, or SqlDataReader.

However this is missing as a parameter.

Related information

• v1.8.2

[smoothdeveloper]

@davidtme thanks for the report, consider contributing a fix at https://github.com/fsprojects/FSharp.Data.SqlClient/blob/master/src/SqlClient/SqlClientProvider.fs#L57

[davidtme]

Thanks for the info @smoothdeveloper but I was hoping to use the User-Defined Table Types as records.

[smoothdeveloper]

@davidtme, sorry missed your point, maybe you can look at this then: https://github.com/fsprojects/FSharp.Data.SqlClient/blob/master/src/SqlClient/SqlClientProvider.fs#L125

the feature should be doable (applies to all commands generated) and relatively easy to write tests for.

[davidtme]

@smoothdeveloper I've had a look and I think it's a bit beyond me at the moment, I've not done any type provider coding yet.

[smoothdeveloper]

If you want this to be implemented, could you rename the issue to something more descriptive and consider posting accurate sample of the feature in use?

[davidtme]

See #258

[smoothdeveloper]

@davidtme FYI I've opened PR #261 with intent to enable specifying ResultType on SqlProgrammabilityProvider.

I'm looking for input (within scope of what ResultType means in other areas of the library) to get it working for various usecases, if you have a chance to give it a look that would be helpful.