querySingleOrNull method

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

At most one row, as a map.

Implementation

Future<Map<String, Object?>?> querySingleOrNull(
  String sql, {
  Object parameters = const <String, Object?>{},
  MssqlQueryOptions options = MssqlQueryOptions.defaults,
  Duration? timeout,
  MssqlCancellationToken? cancellationToken,
}) async {
  final rows = await queryRows(
    sql,
    parameters: parameters,
    options: options.limitedTo(2),
    timeout: timeout,
    cancellationToken: cancellationToken,
  );
  if (rows.length > 1) throw const MssqlMultipleRowsException();
  return rows.isEmpty ? null : rows.single;
}