SQLProvider

SQLProvider copied to clipboard

Error with Oracle

3

### Description When doing simple queries on some oracle tables, the TP raises an exception ### Repro steps 1. Use Oracle Docker Image 2. Use the following gist as a...

imetallica

How to pass null/None to Procedure?

5

``` sql CREATE PROCEDURE dbo.test ( @OptionalParam INT = NULL ) AS SELECT 1 ``` ``` fsharp //Snip... [ for r in db.Procedures.test.Invoke(None).ResultSet -> r.MapTo () ] //Error: Expression was...

legomind

Cannot build SqlServer Tests Project on Windows with .Net Core 2.2

11

### Description Cannot build SqlProvider Core test project on Windows with .NetCore 2.2. Fails with error message: > FSC: error FS0226: The file extension of 'C:\Program Files\dotnet\sdk\2.2.300\FSharp\fsc.exe' is not recognized....

mackenzie-orange

### Description When a table has 2 or more columns whose names are only different by "special" characters, SQLProvider creates indistinct mappings for them. ### Repro steps 1. Create a...

ghost

Any Optimistic Concurrency Control support (MS SQL Server)?

2

### Description I'm looking for a way to add Optimistic Concurrency Control in SQLProvider, based on TIMESTAMP columns (MSSQL). Similar to how it is done in Entity Framework. Is there...

DunetsNM

Having trouble referencing .NET Standard class library using SQLProvider from .NET Core project

5

Reproduction of problem here: https://github.com/Arrow7000/SqlProviderTest I'm fairly new to the .NET world so am having trouble wrapping my head around exactly what the problem is. I've tried to use the...

Arrow7000

SELECT chooses all columns when using quoted queries

2

Consider this: ```f# let cardsAndUsers = let cardIdsAndUserIds = query { for c, u in (%cardsAndUsers) do select (c.Id, u.Id) } ``` When I execute this, I would expect the...

cmeeren

Can't add connection string in fsx file

1

### Description When adding a new connection to the typeprovider like this: `let [] CompileTimeConnectionString = "Data Source=..."` `type Sql = SqlDataProvider` I receiving following error message: > This expression...

tforkmann

error when changing database catalog, with same user credentials and db properties

7

as reported here https://stackoverflow.com/questions/55632576/f-type-providers-2-databases-one-can-access-metadata-one-cant db Schema permissions are identical. VS community 2017. F# .net core 2.1 Project, using type providers specifically SQLProvider - 1.1.16 Fsharp.Core 4.5.2 Fsharp.Data 3.0.1 System.Data.SqlClient 4.6.0...

yetanotherlogonfail

Oracle: outer join retrieves no result

10

When using query with outer join syntax (operator !!) no results are retrieved in case the joined table has no matching rows, so outer join works as inner join. Example:...

object