This pull request solves #31 and does the following.
Makes ExecuteScalar return the value of the first column of the first row of the result set, thus making it possible to get avalue of any type with a call to ExecuteScalar. As a result, we can use ExecuteScalar with any query, just like MSDN says.
Makes ExecuteNonQuery return the number of affected rows using the proper DuckDb API.
Makes DuckDbCommand throw InvalidOperationException in case of a query against a closed DB connection.
This pull request solves #31 and does the following.
ExecuteScalarreturn the value of the first column of the first row of the result set, thus making it possible to get avalue of any type with a call toExecuteScalar. As a result, we can useExecuteScalarwith any query, just like MSDN says.ExecuteNonQueryreturn the number of affected rows using the proper DuckDb API.Fix #31