SQLProvider

SQLProvider copied to clipboard

Does SQLProvider support strongly typed sproc results?

2

I am trying to call a stored procedure using SQLProvider, but it seems that I don't get a return value with the strongly typed columns. [The documentation](https://fsprojects.github.io/SQLProvider/core/programmability.html) also seems to...

cmeeren

It doesn't look like it's currently supported, but with MSSQL you can query temporal tables with statements like this: ```sql SELECT SomeCol FROM dbo.MyTable // different variants: FOR SYSTEM_TIME ALL;...

Shmew

Does not build in CLI for .net core 3.1

5

**Describe the bug** Builds in visual studio 2019 but not using "dotnet build" or in Linux container ERROR: `The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not load type 'System.Data.SqlClient.SqlConnection'...

ZergRushJoe

Compilation issue with .net core 3.1

2

**Describe the bug** When trying to get the type of the DB using `type Db = SqlDataProvider`, VS throws `Error FS3033 The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Unable to...

vparadis

ODBC support for 64bit odbc drivers? The table schema is missing in the sql and also the limit clause...

21

**Is your feature request related to a problem? Please describe.** I have a 64 bit odbc driver and I'm looking for a basic support, nothing fancy, but, at first try,...

giuliohome

Name Collision

3

I’m trying to use the sql provider with our production ms sql database schema however I’ve found a problem which I can’t seem to work around. One of our table...

davidtme

Filtering with Linq.Where

2

**Describe the bug** Trying to execute a join and filtering using Linq.Where on the second table produces a sql where clause where the field is linked to the first table...

mauriciomagni

Provide access to the OracleConfiguration

3

In my work environment the default SQLNET.ORA file has SQLNET.AUTHENTICATION_SERVICES set to nts and kerberos5 - these are the company standards and I can't do anything about them. When I...

rjmccann101

### Description When creating an Android project (in this case using https://github.com/fsprojects/Fabulous ) and using SQLProvider with npgsql (PostgreSql database), an error occurs that only happens in the release build...

MicaelMor

Calling stored procedure with arguments with default values. Wrong types generated in ORM

10

### Description If the SQL procedure has the input argument with default NULL value like f.e. ``` create procedure [dbo].[create_config] @CreateDate datetime = NULL, @UpdateDate datetime = NULL, @DeleteDate datetime...

dmitryrusak