Click or drag to resize
SqlMapperQuery Method (IDbConnection, Type, String, Object, IDbTransaction, Boolean, NullableInt32, NullableCommandType)
Executes a query, returning the data typed as per the Type suggested

Namespace: Dapper
Assembly: VirtualRadar.Database (in VirtualRadar.Database.dll) Version: 1.0.0.0 (1.0.0.0)
Syntax
public static IEnumerable<Object> Query(
	this IDbConnection cnn,
	Type type,
	string sql,
	Object param = null,
	IDbTransaction transaction = null,
	bool buffered = true,
	Nullable<int> commandTimeout = null,
	Nullable<CommandType> commandType = null
)

Parameters

cnn
Type: System.DataIDbConnection
type
Type: SystemType
sql
Type: SystemString
param (Optional)
Type: SystemObject
transaction (Optional)
Type: System.DataIDbTransaction
buffered (Optional)
Type: SystemBoolean
commandTimeout (Optional)
Type: SystemNullableInt32
commandType (Optional)
Type: SystemNullableCommandType

Return Value

Type: IEnumerableObject
A sequence of data of the supplied type; if a basic type (int, string, etc) is queried then the data from the first column in assumed, otherwise an instance is created per row, and a direct column-name===member-name mapping is assumed (case insensitive).

Usage Note

In Visual Basic and C#, you can call this method as an instance method on any object of type IDbConnection. When you use instance method syntax to call this method, omit the first parameter. For more information, see Extension Methods (Visual Basic) or Extension Methods (C# Programming Guide).
See Also