SQLProvider

SQLProvider copied to clipboard

### Description I have the following query for oracle : ``` let qry = query { for cust in ctx.Onur.Customers do join order in (!!) ctx.Onur.Customers on (cust.CustomerId = order.CustomerId)...

OnurGumus

Is there any way to make local mode more user-friendly?

1

The way local mode currently works, the properties for entites are only saved locally if and only if you do a fresh build with no local mode, refresh the project,...

WreckedAvent

Issue when registering into SQL server a SQL CLR assembly referencing SQLProvider

4

### Description I have a F# DLL (.NET Framework 4.5.1, F# 4.1, FSharp.Core 4.4.3.0). The only added reference is to FSharp.Data.SqlProvider 1.1.41. The code is in on file only ```...

francotiveron

Sqlite on netcore2 x64 example request (Ionide)

2

### Description I'm trying to execute the sqlite example. I builds and runs with "dotnet run" but unfortunately in VSCode x64 and Ionide are not get resolved and don't compile....

cotyar

### Description I cannot update a row containing a datetime2(7) column in SQL Server. Updates on other datatypes, for example plain int works well. Inserts with DateTime into this same...

MikaelUmaN

Runtime System.Exception when ContextSchemaPath is defined

11

### Description When the ContextSchemaPath locally cached schema file is defined and present, SQLProvider returns `System.Exception: !` when performing database operations at runtime. ### Repro steps 1. Generate a local...

keyset

### Description When a record is inserted in a table that has a multi-column primary key, the Identity value generated is not retrieved. ### Repro steps 1. Create a silly...

mauriciomagni

[PostgreSQL] Comparing jsonb columns to string values in WHERE statements

8

... results in an error `"operator does not exist: jsonb = text"`. This is because the `filterBuilder` function does not add a type cast for PostgreSQL types which are treated...

piaste

Out Of Memory Exception

3

### Description I have a table with 743537 records Select count(*) from [dbo].[ADDRESS] Running the TP against it causes an OOM exception ### Repro steps When I run this code:...

jamessdixon

F# SqlProvider fails to update changes in a dBase DBF file with ODBC connection

7

Please see https://stackoverflow.com/questions/50401770/f-sqlprovider-fails-to-update-changes-in-a-dbase-dbf-file-with-odbc-connection for a detailed description

francotiveron