FSharp.Data.SqlClient

FSharp.Data.SqlClient copied to clipboard

DataTable types coming from `SqlCommandProvider` don't have natural setters for the column accessor. The work around is kind of unatural / unwieldy: ```fsharp type MyCommand = SqlCommandProvider< myConnection, myQuery, ResultType...

smoothdeveloper

Option not inferred for optional sproc parameters of type binary and nvarchar

2

### Description SqlClient does not infer the correct optionality for all stored procedure parameters. For example, given this sproc with three optional parameters ```sql CREATE PROCEDURE [dbo].[Procedure1] @param1 int =...

cmeeren

Include Task-based execution on SqlCommandProvider

3

It would be nice to have the option of using Task rather than Async when combining workflows with other asynchronous behaviors. Pretty much any third party library in the .NET...

VTJDailey

Add support for netcore/netstandard based tooling (for example FAKE)

16

See conversation in https://github.com/fsharp/FAKE/issues/2272 Basically, we should ship a `netstandard` based design-time assembly.

matthid

Question: For what reason would a SPROC not have an available constructor?

5

I am trying to use the SqlProgrammabilityProvider to execute stored procedures. I've set up some basic crud operations for a DataType on my project: - Select (int -> Option\) -...

willnationsdev

This is taking the spirit of what is written there regarding `FSharp.*` namespaces: https://github.com/fsharp/fsharp.github.io/blob/master/_posts/2014-09-19-fsharp-libraries.md > We need to avoid pollution of the FSharp.* namespace, particularly by unfinished projects. and considering...

smoothdeveloper

In a `netstandard2.0` project I have this: ```f# new SqlCommandProvider() ``` When I run the app (ASP.NET Core targeting `net472`) and make a DB query, I get an exception saying...

cmeeren

What int is returned when Executing a DELETE or UPDATE?

1

```fsharp let x = use cmd = new SqlCommandProvider(conn) cmd.Execute() ``` `x` is an int. What does it represent? Number of rows affected? A status code?

charlesroddie

Assertion in findTypeInfoBySqlEngineTypeId

1

Seen it twice in few days: 

smoothdeveloper

docs of SqlCommandProvider is missing info on TempTableDefinitions and TableVarMapping

1

### Description The docs are missing info on TempTableDefinitions and TableVarMapping on the SqlCommandProvider. ### Expected behavior All options should be documented. ### Actual behavior Go to http://fsprojects.github.io/FSharp.Data.SqlClient/configuration%20and%20input.html and they...

chinwobble