31 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
54
views
F# FSharp.Data.SqlClient error 0x8007007E
I'm attempting to implement the very first example from here and I'm getting Unable to load DLL 'sni.dll' or one of its dependencies error. I have .NET 8/VS Code. Any thoughts?
#r "nuget: FSharp....
2
votes
2
answers
1k
views
FS0039: The namespace is not defined
I'm building a Web API in F# to test some things out. I come from a C# background and I've structured things how I do there.
You can find the repo here: https://github.com/MrGodlike6/WebApiTest
I've ...
1
vote
1
answer
208
views
How to Update Multiple Fields from an Object with FSharp.Data.SqlClient
I've been looking into F# in relation to CRUD with data . and I have been using FSharp.Data.SqlClient
I can't see an easy way to update all fields from an object.
For example I want to execute the ...
3
votes
0
answers
235
views
F# Type provider FSharp,Data.SqlClient targeting .NetStandard 2.0 fails when using dotNet Build from commandLine but succeeds in Visual Studion 2019
I am using the F# Type Provider FSharp.Data.SqlClient in a DLL targeting .Net-Standard-2.0, while this successfully builds in Visual Studio 2019 it fails when I try to build it using the command ...
2
votes
1
answer
446
views
F# - FSharp.Data.SqlClient – How to specify timeout for Update
I use FSharp.Data.SqlClient type providers to access SQL server database. So, I set up the types in F# something as follows:
type ClmDB = SqlProgrammabilityProvider<ClmSqlProviderName, ConfigFile =...
0
votes
1
answer
262
views
F# - FSharp.Data.SqlClient - update row after getting identity value
Let’s say that I have the following:
SQL
Create database called Clm, then run this script:
CREATE TABLE dbo.ModelData(
modelId bigint IDENTITY(1,1) NOT NULL,
numberOfAminoAcids int NOT NULL,...
2
votes
1
answer
244
views
Project with generated types fails on Assembly.GetExportedTypes()
I'm working on upgrading FSharp.Data.SqlClient to the latest version of the Type Provider SDK and I'm seeing an error when using generated types. The test project, which references numerous generated ...
0
votes
2
answers
210
views
Compile-time error with generative type provider
I've run into an issue with on a branch of FSharp.Data.SqlClient I am working on with the generative SqlEnumProvider type provider. When the test project attemps to use a provided type, I get the ...
2
votes
2
answers
340
views
Why is the program still running while Error FS0039 The type 'JsonProvider' is not defined?
I'm trying to learn Fsharp.data with the example of JsonProvider, but I can not understand why I'm still running the program while compiling the error.
4
votes
1
answer
883
views
F# filtering records with many option types
Okay, strange question here. I'm using FSharp.Data.SqlClient to get records from our Database. The records that it infers have several fields which are option types. I need to filter out the records ...
1
vote
1
answer
272
views
FSharp.Data.SqlCient works locally but not on production server
I am having an issue with FSharp.Data.SqlClient. I am building an Asp.net Core full framework 4.6 web app. The main project is in C# which references several projects that are in F#. Each of these F# ...
3
votes
1
answer
177
views
FSharp.Data.SqlClient with multiple result sets
With FSharp.Data.SqlClient, how do you use SqlCommandProvider or SqlProgrammabilityProvider with multiple result sets? For instance if you wanted to get Customer+Orders where your stored procedure ...
2
votes
1
answer
83
views
Using Fsharp.Sql.DataClient via a referenced project in asp.net core
I am building an Asp.net Core (.NET Framework 4.6.2) project. I added a referenced F# project that uses FSharp.Sql.DataClient. When I call the F# code from the main project to retrieve data from the ...
4
votes
2
answers
310
views
f# sqlite sqlprovider minBy maxBy using float
I have a sqlite table with a mix of integer and float columns. I'm trying to get the max and min values of each column. For integer columns the following code works but I get a cast error when using ...
2
votes
2
answers
322
views
Populate list with Types
Im trying to populate list with my own type.
let getUsers =
use connection = openConnection()
let getString = "select * from Accounts"
use sqlCommand = new SqlCommand(getString, ...