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

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

Parameters

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

Type Parameters

T

Return Value

Type: IEnumerableT
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).
Remarks
the dynamic param may seem a bit odd, but this works around a major usability issue in vs, if it is Object vs completion gets annoying. Eg type new [space] get new object
See Also