SQLProvider

SQLProvider copied to clipboard

Querying for metadata from Information_Schema

2

I was wondering if their is a convenient way to use this library to pull metadata from a database. In pure SQL I would generally do this by querying the...

bisen2

The type 'SqlDataProvider' is not defined

4

Hi, I tried to create a simplest possible program to test the SQLite connection using the SQLProvider. I use MS Visual Studio 2017, FW 4.7.2, Win10. Here is a code:...

dmitryrusak

Cannot negate Option.IsSome condition?

2

**Is your feature request related to a problem? Please describe.** I seem not to be able to negate a boolean `Option.IsSome` or a boolean `Option.IsNone`. Also the error messaging of...

halcwb

Inverse of `.MapTo<'T>`

4

**Is your feature request related to a problem? Please describe.** This library provides the `.MapTo Some( foundRow.MapTo() ) | None -> None ``` This method is independent of the number...

bisen2

Accessing Table-Valued Functions?

15

Is there a way to access a table-valued function with the SQL Provider?

tforkmann

Allow developers to extend/create their own the OnConflict clause

1

https://github.com/fsprojects/SQLProvider/blob/8afaad203efe2b3b900a2ad1a6d8a35d66ebe40a/src/SQLProvider.Runtime/Providers.Postgresql.fs#L516 Is there any way to create / use a custom "ON CONFLICT" clause? It looks like this should be easily extendible by adding another case to the `OnConflict` discriminated...

kurt-mueller-osumc

Can't join two queries when one has a `where` clause

5

**Describe the bug** When running a composable query with two composed queries which each have `where` clauses, an exception is thrown. It appears to be the case that the FilterClause...

MaybeSacred

Unknown column 'c.generation_expression' in 'field list' when connecting to MySQL database

3

I'm attempting to connect to a MySQL database hosted in RDS, but am running into issues actually running queries against it. I know the connection is working because I can...

joshdean-ts

ISqlDataContext.SubmitPendingChanges suppressing exceptions

9

**Describe the bug** When updating from an old version (1.1.5.0), we are finding that SQL exceptions are being ignored when calling SubmitPendingChanges. I have tracked it down to 1.1.38, the...

raquila

How to do unit testing on my code when using SQLProvider?

8

What are the best practices to do unit testing with SQLProvider? Let's say that I have a method: ```fsharp let myLogic email = let usr = query { for u...

Thorium