Question: Is there a way to read just a scalar value from the query?

[groma84]

I'm trying out Fumble at the moment for a small project and tried reading just a scalar value from the DB:
SELECT COUNT(*) FROM Test.
But then I don't know how to get the resulting number (which does not have a column name) with the SqlRowReader.

I for now use a workaround (naming the resulting count as a column with AS in the statement). Just wanted to know if there's a shorter way.

Thanks for the great library!

[njlr]

SqlRowReader can take a column index instead of a column name.

#r "nuget: Fumble, 0.8.1"

open Fumble

let tryFetchCount db =
  db
  |> Sqlite.query "SELECT COUNT(*) FROM Test"
  |> Sqlite.execute (fun read -> read.int 0)
  |> Result.map List.exactlyOne

[tforkmann]

@groma84 Did that work for you?