FSharp.Data.SqlClient icon indicating copy to clipboard operation
FSharp.Data.SqlClient copied to clipboard

What int is returned when Executing a DELETE or UPDATE?

Open charlesroddie opened this issue 6 years ago • 1 comments

let x =
    use cmd = new SqlCommandProvider<"DELETE FROM...", designTimeConn>(conn)
    cmd.Execute()

x is an int. What does it represent? Number of rows affected? A status code?

charlesroddie avatar Sep 26 '19 14:09 charlesroddie

@charlesroddie, AFAIR it corresponds to the return value of ExecuteNonQuery, the number of rows impacted by the statement.

https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlcommand.executenonquery?view=netframework-4.8#returns

smoothdeveloper avatar Sep 26 '19 15:09 smoothdeveloper