SQLProvider

SQLProvider copied to clipboard

[Question] How to use Pragma with SQLITE?

6

When you use pragma statements with sqlite, you need to do it at the beginning of your connection. I am not sure how this is achievable with SqlProvider, any hints...

OnurGumus

Issue with connecting to PostgreSQL database

1

**Describe the bug** I am trying to establish a connection with PostgreSQL. Following this docs site: https://fsprojects.github.io/SQLProvider//core/postgresql.html I have copied _Npgsql.dll_ in the chosen location and provided a path to...

wis-niowy

**Describe the bug** SqlProvider + postgresql with Rider but not Visual Studio 2022 Set up the provider as per usual using rider ```f# [] let private designTimeDataConnStr = @"Server=127.0.0.1;Database=WGDDev;Username=WGDApp;Password=" []...

kgday

`SqlDataProvider` does not have the functionality to specify schema of stored procedure (in contrast to accessing the tables). Rather, all stored procedures appear under `ctx.Procedures` where `ctx` is a database...

kkkmail

Incorrect FROM statement is produced when a table name contains periods

2

**Describe the bug** Using SQLProvider 1.3.8 Given a SQL table named `A.B.C` This f# code: `for t in ctx.Dbo.ABC` Produces this FROM statement when querying SQL Server: `FROM [dbo.A.B].[C]` instead...

jasonmcboyd

Add user defined function call support for MSSQL

3

## Proposed Changes WIP ## Types of changes - [ ] Bugfix (non-breaking change which fixes an issue) - [X] New feature (non-breaking change which adds functionality) - [ ]...

MMagueta

The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: System.Data.SqlClient is not supported on this platform

12

**Describe the bug** Cannot execute a query in a .net 6 project. **To Reproduce** Steps to reproduce the behavior: 1. Create a new .NET 6 web F# web application in...

houdelou

**Describe the bug** Like Firebug (#431) Oracle also has a problem with quoted table names. Actually the same goes for schema names and column names as well. ([ref](https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Database-Object-Names-and-Qualifiers.html#GUID-75337742-67FD-4EC0-985F-741C93D918DA)). When a...

keimpema

**Describe the bug** We have a schema name like `my-schema` in MySQL. When querying this schema we are required to enclose it in backticks to escape the hyphen. It seems...

Choc13

Missing ``Create(...)`` function

3

After reading the docs I wanted to use the ``Create(...)`` style function as recommended, to ensure that if the columns in the DB change my code will fail to compile...

Choc13