queryScalarOrNull<T> method

Future<T?> queryScalarOrNull<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, or null when there is no row.

Implementation

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