EntityConnectionExtensions.ListAsync<TRow> method (1 of 3)

Asynchronously lists all records. This method selects only the table fields, and no foreign / calculated fields. Use other overloads if you want to select different set of fields.

public static Task<List<TRow>> ListAsync<TRow>(this IDbConnection connection, 
    CancellationToken cancellationToken = default)
    where TRow : class, IRow, new()

parameter	description
TRow	The type of the row.
connection	The connection.
cancellationToken	The cancellation token.

Return Value

A task representing the asynchronous operation. The task result is all records.

See Also

• interface IRow
• class EntityConnectionExtensions

---

EntityConnectionExtensions.ListAsync<TRow> method (2 of 3)

Asynchronously lists the records, allowing the caller to specify criteria and set of fields to select through an editQuery callback.

public static Task<List<TRow>> ListAsync<TRow>(this IDbConnection connection, 
    Action<SqlQuery> editQuery, CancellationToken cancellationToken = default)
    where TRow : class, IRow, new()

parameter	description
TRow	The type of the row.
connection	The connection.
editQuery	The edit query callback.
cancellationToken	The cancellation token.

Return Value

A task representing the asynchronous operation. The task result is the list of records matching the edited query.

See Also

• class SqlQuery
• interface IRow
• class EntityConnectionExtensions

---

EntityConnectionExtensions.ListAsync<TRow> method (3 of 3)

Asynchronously lists the records matching specified where criteria. This method selects only the table fields, and no foreign / calculated fields. Use other overloads if you want to select different set of fields.

public static Task<List<TRow>> ListAsync<TRow>(this IDbConnection connection, ICriteria? where, 
    CancellationToken cancellationToken = default)
    where TRow : class, IRow, new()

parameter	description
TRow	The type of the row.
connection	The connection.
where	The where criteria.
cancellationToken	The cancellation token.

Return Value

A task representing the asynchronous operation. The task result is the records matching the specified criteria.

See Also

• interface ICriteria
• interface IRow
• class EntityConnectionExtensions