SQLProvider

SQLProvider copied to clipboard

Using Oracle Wallet in connection string

3

### Description Hi I want to use an oracle wallet as a part of my connection string but I can't seem to be able to get it to work with...

Pranav180495

RunTests target fails when no .NET 3.5 installed

2

### Description Running build.cmd (as per build instructions) fails on Windows with no .NET 3.5 framework installed. ### Expected behavior All green build. ### Actual behavior ``` Starting Target: RunTests...

jlogar

Could not load file or assembly 'Microsoft.Extensions.Logging.Abstractions, Version=8.0.0.0

25

**Describe the bug** The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not create the connection, most likely this means that the connectionString is wrong. See error from Npgsql to troubleshoot:...

jkone27

SQLite Provider using Microsoft.Data.Sqlite library does not perform updates transactionally

7

**Describe the bug** Updates from SQLProvider should be transactional. In the example below, the row in the Parent table is created even though the creation of the Child row fails...

FedericoBinda

dotnet 8.0.100-preview.6.23330.14 error.

12

**Describe the bug** when I try to build with dotnet 8.0.100-preview.6.23330.14 sdk i get this error: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Un able to load one or more...

WillEhrendreich

not working macos net8 ## Proposed Changes Fix PGSQL on NET8 and MacOs, not working yet. ``` error FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Could not create the...

jkone27

OnConflict.Update ignores None/ValueNone values when using DatabaseProviderTypes.POSTGRESQL

2

Hi! **Describe the bug** If I create following simple key-value pairs Postgresql database: ```sql begin; create table "Test" ( "ID" int4 generated by default as identity primary key, "Value" int4...

mishun

Simple group by query with postgresql causes doubling up of double quotes when using double quoted declared fields

3

In PostGreSq with a table where the fields are declared double quotedl, I have the following query: ``` let! costs = query { for pol in ctx.Public.PurchaseOrderLine do where (pol.JobId.Value...

kgday

OnConflict implementation for SQLite provider uses wrong feature of SQLite

3

**Describe the bug** I think that implementation of OnConflict uses wrong feature of SQLite. If you check the [SQLite docs](https://sqlite.org/lang_conflict.html) mentioned in https://fsprojects.github.io/SQLProvider/core/crud.html#OnConflict you'll see that "ON CONFLICT clause applies...

gbtb

[Microsoft,System].Data.SqlClient is not supported on this platform

20

**Describe the bug** SqlDataProvider gives compile error related to the use of Microsoft.Data.SqlClient in a fresh install of Console template in F# .Net 6.0.113 on Ubuntu 22.04. Problem is reported...

moh-incom