Error: Invalid attempt to call Read when reader is closed.

[eadgbear]

I'm trying to use FsBeaker to do some simple charting demonstrations based on some data from SQL, however I cannot get it to actually make a query to the server. Using SQLClient (and having confirmed it works in FSI) I'm only ever able to get it to spit out the above error.

I'm trying to investigate if this extends to other IDisposables or not.

[prosconi]

If you can post some example code here I can help

[eadgbear]

I've tried this code, both in an Async and Synchronous fashion and they all end up with the same problem.

#r "packages\FSharp.Data.SqlClient.dll"
open FSharp.Data
open Deedle

[<Literal>]
let connectionString = @"Data Source=(LocalDB)\v11.0;Initial Catalog=C:\USERS\SLYONS\ONEDRIVE\DOCUMENTS\DATASMART.MDF;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False"
[<Literal>]
let query = "SELECT CS.Item, 
        CS.Category, 
        CS.Price, 
        CS.Profit,
        CA.Calories
FROM Concessions CS JOIN Calories CA 
ON CS.Item = CA.Item"

type ConcessionsCalories = SqlCommandProvider<"SELECT 42", connectionString>
let cmd = new ConcessionsCalories()
cmd.Execute()