FSharp.Data.SqlClient

FSharp.Data.SqlClient copied to clipboard

Add streaming support

2

System.Data.SqlClient (and Microsoft.Data.SqlClient) supports [streaming binary data](https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sqlclient-streaming-support). For example, here is how data can be streamed to the DB (untested): ```f# let insertFile (connStr: string) (filename: string) (stream: Stream) :...

cmeeren

Netcore DTC

4

@smoothdeveloper Addressing #337 - still a work in progress and I'm not sure I have tested all the use cases, but this works with the test projects. However, I have...

samhanes

Add support for NetTopologySuite

2

### Description In the past this type provider had support for `SqlServer.Types` a big part of which are the Spatial Data Types for SQLServer. Today with the move to dotnetcore...

daniellittledev

Multi column PK may result in System.Data.ConstraintException when PK is widened

1

### Description After extending multi column PK, bulk insert with the data different only in the new column fails with System.Data.ConstraintException. ### Repro steps 1. Create table `EFTests`: ``` CREATE...

kkkmail

build.cmd on master fails with "Could not load file or assembly 'System.Data.SqlClient'"

2

I'm working on #348, but it's a bit hard to contribute to the project, because running `build.cmd` (even on a clean checkout of `master`) fails on the `BuildTestProjects` target: >...

cmeeren

Allow database metadata to be saved to a local file

18

Would really like it if this were possible; I might be able to contribute if required. I would like the database to be a dependency only during the first build...

mvkara

SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns

2

### Description SqlProgrammability provider fails to update/bulk copy into tables with computed persistent columns - you get exception when you call update method: ```System.Data.NoNullAllowedException: Column '{persistentColumn}' does not allow nulls.```...

ntr

SqlProgrammabilityProvider design-time: "The given key was not present in the dictionary" and then "No constructors are available" the first time an sproc is used until project reload

2

The first time I use an sproc in code using `SqlProgrammabilityProvider`, I often get the following error: > The given key was not present in the dictionary  Then after...

cmeeren

Add AllParametersOption as safer alternative to AllParametersOptional

9

Using `AllParametersOptional` is more dangerous than it needs to be. Since it makes all parameters optional, you get no compile-time check when you add new parameters to your SQL and...

cmeeren

cannot build netstandard2.0 project with the dotnet SDK build

2

### Description Cannot build as a netstandard2.0 project with the dotnet SDK build. ### Repro steps I have a test project where various SDK versions can be tried. https://github.com/jackfoxy/TestSqlClient ###...

jackfoxy