EntityConnectionExtensions.TrySingleAsync<TRow> method (1 of 2)

Asynchronously tries to find a single entity, allowing caller to edit the criteria and set of fields to load through a editQuery callback.

public static Task<TRow> TrySingleAsync<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.
cancellationToken	The cancellation token.

Return Value

A task representing the asynchronous operation. The task result is the single entity matching the criteria set by editQuery, or null if not found.

Exceptions

exception	condition
InvalidOperationException	Multiple records matching the specified criteria.

See Also

• class SqlQuery
• interface IRow
• class EntityConnectionExtensions

---

EntityConnectionExtensions.TrySingleAsync<TRow> method (2 of 2)

Asynchronously tries to find a single entity matching the specified 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<TRow> TrySingleAsync<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 single entity matching the specified criteria, or null if no matching record is found.

Exceptions

exception	condition
InvalidOperationException	Multiple records matching the criteria found.

See Also

• interface ICriteria
• interface IRow
• class EntityConnectionExtensions