queryScalar<T> method

Future<T> queryScalar<T>(
  1. String sql, {
  2. Object parameters = const <String, Object?>{},
  3. MssqlQueryOptions options = MssqlQueryOptions.defaults,
  4. Duration? timeout,
  5. MssqlCancellationToken? cancellationToken,
})
inherited

The first column of the single row, as T.

A SQL NULL is a conversion error here unless T is nullable; use queryScalarOrNull when NULL is a legitimate answer.

Implementation

Future<T> queryScalar<T>(
  String sql, {
  Object parameters = const <String, Object?>{},
  MssqlQueryOptions options = MssqlQueryOptions.defaults,
  Duration? timeout,
  MssqlCancellationToken? cancellationToken,
}) async {
  final row = await querySingle(
    sql,
    parameters: parameters,
    options: options,
    timeout: timeout,
    cancellationToken: cancellationToken,
  );
  return _scalarOf<T>(row);
}