count method

Future<int> count(
  1. MssqlSession session, {
  2. MssqlDialect dialect = MssqlDialect.sql2012,
  3. Duration? timeout,
  4. MssqlCancellationToken? cancellationToken,
  5. MssqlQueryOptions options = MssqlQueryOptions.defaults,
})

How many rows this query returns.

See MssqlQuery.countRows for what that means when the query has a DISTINCT, a GROUP BY or a page: the count follows the query's shape rather than discarding it.

Implementation

Future<int> count(
  MssqlSession session, {
  MssqlDialect dialect = MssqlDialect.sql2012,
  Duration? timeout,
  MssqlCancellationToken? cancellationToken,
  MssqlQueryOptions options = MssqlQueryOptions.defaults,
}) async {
  final rows = await countRows().get(
    session,
    dialect: dialect,
    timeout: timeout,
    cancellationToken: cancellationToken,
    options: options,
  );
  return rows.isEmpty ? 0 : (rows.first.at(0)! as num).toInt();
}