Function query
Execute a one-off SQL command for the case where you expect a result set, and want to deal with it a row at a time.
Use this method when you are not going to be using the same command repeatedly. This method will throw if the SQL command does not produce a result set.
If there are long data items among the expected result columns you can specify that they are to be subject to chunked transfer via a delegate.
Prototype
ResultRange query(
Connection conn,
string sql,
ColumnSpecialization[] csa = null
);
Parameters
| Name | Description |
|---|---|
| csa | An optional array of ColumnSpecialization structs. |
Returns
A (possibly empty) ResultRange.