SqlMapper.QueryAsync method (1 of 4)

namespace: Serenity.Data   assembly: Serenity.Net.Services

Returns a list of dynamic objects asynchronously; the reader is closed after the call. Serenity specific overload for ISqlQuery, not present in Dapper.

public static Task<IEnumerable<object>> QueryAsync(this IDbConnection cnn, ISqlQuery sql, 
    IDbTransaction transaction = null, int? commandTimeout = null, 
    CommandType? commandType = default(CommandType?), 
    CancellationToken cancellationToken = default(CancellationToken))

parameter	description
cnn	The connection.
sql	The SQL query.
transaction	The transaction.
commandTimeout	The command timeout.
commandType	Type of the command.
cancellationToken	The cancellation token.

Return Value

A task that represents the asynchronous operation. The task result contains a list of dynamic objects.

See Also

• interface ISqlQuery
• class SqlMapper

---

SqlMapper.QueryAsync method (2 of 4)

namespace: Serenity.Data   assembly: Serenity.Net.Services

Returns a list of dynamic objects asynchronously; the reader is closed after the call.

public static Task<IEnumerable<object>> QueryAsync(this IDbConnection cnn, string sql, 
    object param = null, IDbTransaction transaction = null, int? commandTimeout = null, 
    CommandType? commandType = default(CommandType?), 
    CancellationToken cancellationToken = default(CancellationToken))

parameter	description
cnn	The connection.
sql	The SQL query.
param	The parameters.
transaction	The transaction.
commandTimeout	The command timeout.
commandType	Type of the command.
cancellationToken	The cancellation token.

Return Value

A task that represents the asynchronous operation. The task result contains a list of dynamic objects.

See Also

• class SqlMapper

---

SqlMapper.QueryAsync<T> method (3 of 4)

namespace: Serenity.Data   assembly: Serenity.Net.Services

Returns a list of values asynchronously; the reader is closed after the call. Serenity specific overload for ISqlQuery, not present in Dapper.

public static Task<IEnumerable<T>> QueryAsync<T>(this IDbConnection cnn, ISqlQuery sql, 
    IDbTransaction transaction = null, int? commandTimeout = null, 
    CommandType? commandType = default(CommandType?), 
    CancellationToken cancellationToken = default(CancellationToken))

parameter	description
T	The type of the value.
cnn	The connection.
sql	The SQL query.
transaction	The transaction.
commandTimeout	The command timeout.
commandType	Type of the command.
cancellationToken	The cancellation token.

Return Value

A task that represents the asynchronous operation. The task result contains a list of values.

See Also

• class T
• interface ISqlQuery
• class SqlMapper

---

SqlMapper.QueryAsync<T> method (4 of 4)

namespace: Serenity.Data   assembly: Serenity.Net.Services

Returns a list of objects asynchronously; the reader is closed after the call.

public static Task<IEnumerable<T>> QueryAsync<T>(this IDbConnection cnn, string sql, 
    object param = null, IDbTransaction transaction = null, int? commandTimeout = null, 
    CommandType? commandType = default(CommandType?), 
    CancellationToken cancellationToken = default(CancellationToken))

parameter	description
T	The type of the objects to return.
cnn	The connection.
sql	The SQL query.
param	The parameters.
transaction	The transaction.
commandTimeout	The command timeout.
commandType	Type of the command.
cancellationToken	The cancellation token.

Return Value

A task that represents the asynchronous operation. The task result contains a list of objects.

See Also

• class T
• class SqlMapper