firstWhere method

Future<TRow?> firstWhere(
  1. MssqlCondition where, {
  2. List<MssqlOrder> orderBy = const <MssqlOrder>[],
})

The first row matching where, or null.

Implementation

Future<TRow?> firstWhere(
  MssqlCondition where, {
  List<MssqlOrder> orderBy = const <MssqlOrder>[],
}) async {
  var query = _base.where(where);
  if (orderBy.isNotEmpty) query = query.orderBy(orderBy);
  final rows = await _run(query.top(1));
  return rows.isEmpty ? null : rows.first;
}