SQLProvider
SQLProvider copied to clipboard
A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
### Description Intellisense worked fine without problem, but when building the project, the following occured `The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Unable to load one or more of the...
### Description (MS SQL SERVER) I have many tables with TIMESTAMP columns, computed columns, columns with default values. Most of the tables have auto-incremented (identity) primary key. I expect that...
( ... Unless I've completely misunderstood how it's supposed to work? ... ) I tried to use a left join in a query and neither the left-joined entity nor its...
Hi, what am I missing here? Connection strings in config.yaml. ``` type ClientDb = SqlDataProvider let ClientCtx= ClientDb.GetDataContext Config.CfgTestB.Db.ConnectionString let Staff = ClientCtx.TestA.Staff |> Seq.toArray ``` The result of the...
Hello, When I start VS2015 and my project opens my SQL.fs file, where the SqlDataProvider is 'typed', it seems SqlDataProvider wins a race to the FSharp.Data.SqlProvider.dll and locks it, making...
### Description The extraction of year, month etc. by adding .Year / .Month to the field does not seem to be reflected in the "select" part of the query. It...
### Description When row is created by ```Created(columnOne,columnTwo...)``` , object mapping to auto_increment column is made as UInt64 even if the column's type is Int. ### Repro steps 1. Create...
### Description executeDeleteQueryAsync in SqlRuntime.Linq.fs doesn't return deleted row count. ### Repro steps Seq.``delete all items from single table`` always returns 0. ### Expected behavior Seq.``delete all items from single...
Why does submit Updates not return a result with either unit or error of what stopped the update
### Description Path to Oracle ODB.NET driver (e.g. Oracle.ManagedDataAccess.dll) is not used for runtime version. When executing a project compiled for .NET 4.7.3 / F# 4.6 with the SQLProvider, I...