SQLProvider

SQLProvider copied to clipboard

Firebird can't be used with case sensitive (quoted) table names

20

### Description I have a DB that uses quoted (camel case) table names. I couldn't find a way to make the provider use correct names so all my queries fail....

jlogar

Question: Support JSON data sources?

1

Should we made some of the internal classes/interfaces (like 'ISqlProvider') public so that there could be another project, to reference/combine both FSharp.Data and SQLProvider, to allow `query { ... }`-syntax...

Thorium

.NET Standard - Stack Overflowing

1

Hey all, I've been investigating an issue by Scott Hutchinson reported here: https://developercommunity.visualstudio.com/content/problem/226479/vs-2017-version-1564-freezes-and-crashes-when-addi.html While I was looking at the issue, it appears that SQLProvider is stack overflowing at design time...

TIHan

Failed on MySQL with schema name containing dash

3

### Description When trying to get Individuals, for example, you'll get the error `error FS3021: Unexpected exception from provided type FSharp.Data.Sql.SqlDataProvider,DatabaseVendor="3",ConnectionString="Server=localhost;Database='prefix-portal';User=user;Password=******",ResolutionPath="c:\\Projects\\tmp\\sql\\MySqlDemo/../../../packages/scripts/MySql.Data/lib/net45",UseOptionTypes="True",Owner="prefix-portal"+dataContext+prefix-portal.customers.Individuals' member 'GetMethods': The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error:...

DmitryBatalov

Count doesn't work on sorted queries (MSSQL)

3

### Description Trying to get a count from a query that has already been sorted throws an exception. ### Repro steps Let's have a sorted query: ``` let q =...

ScRyX

Type Provider putting in extra backslash before non-default parameter values.

4

### Description TP puts in an extra `\` (backslash) before any non-default parameter values. I noticed this first by specifying a value for the the `Owner` parameter (see this issue...

siklosg

Invalid SQL produced when using sortBy after nested query.

3

### Description The type provider produces invalid SQL (in my case I used SQLite) when using a `sortBy` or `sortByDescending` after a nested query. ### Repro steps **I have added...

nikonthethird

[SQL SERVER] Dealing with nulls values and timestamp columns during insert

4

### Description As an exercise I've ported a small console application that sync tables in SQL SERVER DB from C# EF to F# SQLProvider. In C# I was able to...

rus-vladimir

[Question] Are composite types defined in PostgreSQL supported by SQLProvider?

12

### Description Database has composite types defined which are input/output types to stored procedures. I am attempting to call the said procedure with input parameters. SqlProvider does not see the...

kirankuppa

I can't insert a row in a Postgresql table. I get a "Method 'System.Transactions.TransactionScope..ctor' not found."

7

### Description I can't insert a row in a Postgresql table. ### Repro steps 1. Create an entity 2. Submit changes Like this: let ctx = sql.GetDataContext() let row =...

laygr