SqlMapper.Query method (1 of 4)

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

public static IEnumerable<object> Query(this IDbConnection cnn, ISqlQuery sql, 
    IDbTransaction? transaction = null, bool buffered = true, int? commandTimeout = null, 
    CommandType? commandType = default)

parameter	description
cnn	The connection.
sql	The SQL query.
transaction	The transaction.
buffered	If set to true, results are buffered.
commandTimeout	The command timeout.
commandType	Type of the command.

Return Value

List of dynamic objects.

See Also

• interface ISqlQuery
• class SqlMapper

---

SqlMapper.Query method (2 of 4)

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

public static IEnumerable<object> Query(this IDbConnection cnn, string sql, object? param = null, 
    IDbTransaction? transaction = null, bool buffered = true, int? commandTimeout = null, 
    CommandType? commandType = default)

parameter	description
cnn	The connection.
sql	The SQL query.
param	The parameters.
transaction	The transaction.
buffered	If set to true, results are buffered.
commandTimeout	The command timeout.
commandType	Type of the command.

Return Value

List of dynamic objects.

See Also

• class SqlMapper

---

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

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

public static IEnumerable<T> Query<T>(this IDbConnection cnn, ISqlQuery sql, 
    IDbTransaction? transaction = null, bool buffered = true, int? commandTimeout = null, 
    CommandType? commandType = default)

parameter	description
T	The type of the value.
cnn	The connection.
sql	The SQL query.
transaction	The transaction.
buffered	If set to true, results are buffered.
commandTimeout	The command timeout.
commandType	Type of the command.

Return Value

List of values.

See Also

• interface ISqlQuery
• class SqlMapper

---

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

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

public static IEnumerable<T> Query<T>(this IDbConnection cnn, string sql, object? param = null, 
    IDbTransaction? transaction = null, bool buffered = true, int? commandTimeout = null, 
    CommandType? commandType = default)

parameter	description
T	The type of the objects to return.
cnn	The connection.
sql	The SQL query.
param	The parameters.
transaction	The transaction.
buffered	If set to true, results are buffered.
commandTimeout	The command timeout.
commandType	Type of the command.

Return Value

List of objects.

See Also

• class SqlMapper