FSharp.Data.SqlClient

FSharp.Data.SqlClient copied to clipboard

SQLite and SqlEnumProvider

4

### Description I'm trying to connect to SQLite ADO.NET provider ### Repro steps Here it is the repro 1. Visual Studio 2016 .Net 462 a new F# console project 2....

giuliohome

Document usage of STRING_SPLIT with IN instead of Table-Valued Parameters

2

It seems the consensus on using `IN` is to explicitly use table-valued parameters, requiring defining types and putting your query in a stored procedure. There's a much easier way that...

cmeeren

Extremely long intellisense on errors

1

When we have an error indicated like this in Visual Studio:  Hovering gives:  Is it something we are doing wrong or a bug in FSharp.Data.SqlClient? Thanks!

charlesroddie

How to get types to update after changing .sql file?

11

Is there a way to get types to update after changing an sql file in `SqlFile` or `SqlCommandProvider`, without restarting Visual Studio?

charlesroddie

1. Includes all database tables 2. Navigation support 3. Ideally reuses same erased types for tables ``` FSharp type DB = SqlProgrammabilityProvider let ds = DB.DataSet() //table types re-use //pseudo...

dmitry-a-morozov

Metadata from SqlCommandProvider

2

Given an instantiated type ```fsharp type MySqlType = SqlCommandProvider use cmd = new TestFirstResultSet(conn) ``` 1) new method ```fsharp DescribeFirstResult(params : string option, browseInformationMode : BrowseInformationMode) BrowseInformationMode.NoInfo 0 BrowseInformationMode.ForBrowse 1...

jackfoxy

### Description I'd like to be able to track the progress of loading a datatable, the library allows to return DataReader but then you are on your own as you...

smoothdeveloper

SqlProgrammabilityProvider with Record based User-Defined Table Types

3

Currently the User-Defined Table Types are classes. Could a config option be added to allow them to be records. Sql Setup: ```SQL --DROP PROCEDURE InsertTypeIntoTable1 --DROP TYPE dbo.Type1 --DROP TABLE...

davidtme

Needs an AllParametersOptional on SqlProgrammabilityProvider or?

1

I'm trying to call a stored procedure but many parameters should allow null. I think a top level `AllParameterOptionals` parameter could be a good short term solution. Longer term, I'd...

smoothdeveloper

Expose a PrepareRawCommand method on SqlCommand objects

4

Due to specifics of return value, I sometimes need to use manually created `System.Data.SqlClient.SqlCommand` objects that I obtain from typed `SqlCommand` objects, I'd like to actually still leverage type checking...

smoothdeveloper