SqlHydra
SqlHydra copied to clipboard
SqlHydra is a suite of NuGet packages for working with databases in F# including code generation tools and query expressions.
I'd like to pull down this project and open it up in vscode with the proper dependencies installed with documentation on how to build the project and run tests. For...
Should be able to make a selected column from a leftJoined table optional by wrapping it with `Some`. For example: ```F# let! results = selectTask HydraReader.Read (Create openContext) { for...
I saw [this issue](https://github.com/JordanMarr/SqlHydra/discussions/28) a while ago and thought I'd contribute. If you'd like a PR instead, I'd be happy to send one over. type SelectQueryBuilder with /// Sets the...
Thanks for the great library. Another thing I've found is probably missing support for tuple query generation in where clauses? ```fsharp selectTask HydraReader.Read ctx { for a in draftItemTable do...
When using SqlHydra.Cli against a Sqlite database, the F# types and readers do not include columns that are of type `longvarchar`. A mapping is missing in `SqlHydra.Cli/Sqlite/SqliteDataTypes.fs ` e.g. `"longvarchar",...
In SQL, I want to write something like ```sql SELECT date_trunc('day', fsvr."CompletedTimeStamp"), fsvr."FormSpecType", count(fsvr."FormSpecType") FROM dbo."FormStudioValuesResult" AS fsvr WHERE fsvr."TenantId" = '9003665c-a1c3-486e-90db-85f7a053ded8' group by 1, fsvr."FormSpecType"; ``` Is it possible...
Hi I am using a select statement getting less colunms than the actual type in the result. ```fs let sql = $""" SELECT g.SiteId, gm.GroupId,g.Title,g.Owner, g.OwnerIsUser,gm.MemberId, u.tp_Login, u.tp_Title, u.tp_Email FROM...
I am trying out the selectTask example exactly as in the documentation on a net8.0 console application. I am getting a warning which i cannot figure out. Am I missing...