fss
fss copied to clipboard
.Query method with array of primitive types gives cryptic error
The .Query method expects a sequence of F# record types as its target. When the user does a simple query of say integers it fails saying that (int32) doesn't have that field name. Would be nice if it identified single value arrays of basic types and handled that gracefully.
`
let getCycle rid =
let sql = sprintf "SELECT run.customer_id FROM dtdqc.run as run WHERE id = %s" rid
let cycle_id =
sql
|> conn.Query
|> Array.ofSeq
cycle_id
And when I run it I get this error:
ERROR: name mapping, SQL name 'customer_id' not found in target Record`