SqlMapperQueryT Method (IDbConnection, String, Object, IDbTransaction, Boolean, NullableInt32, NullableCommandType) |
Executes a query, returning the data typed as per T
Namespace: DapperAssembly: 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
)
<ExtensionAttribute>
Public Shared Function Query(Of T) (
cnn As IDbConnection,
sql As String,
Optional param As Object = Nothing,
Optional transaction As IDbTransaction = Nothing,
Optional buffered As Boolean = true,
Optional commandTimeout As Nullable(Of Integer) = Nothing,
Optional commandType As Nullable(Of CommandType) = Nothing
) As IEnumerable(Of T)
public:
[ExtensionAttribute]
generic<typename T>
static IEnumerable<T>^ Query(
IDbConnection^ cnn,
String^ sql,
Object^ param = nullptr,
IDbTransaction^ transaction = nullptr,
bool buffered = true,
Nullable<int> commandTimeout = nullptr,
Nullable<CommandType> commandType = nullptr
)
[<ExtensionAttribute>]
static member Query :
cnn : IDbConnection *
sql : string *
?param : Object *
?transaction : IDbTransaction *
?buffered : bool *
?commandTimeout : Nullable<int> *
?commandType : Nullable<CommandType>
(* Defaults:
let _param = defaultArg param null
let _transaction = defaultArg transaction null
let _buffered = defaultArg buffered true
let _commandTimeout = defaultArg commandTimeout null
let _commandType = defaultArg commandType null
*)
-> IEnumerable<'T>
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:
IEnumerableTA 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