SqlMapperExecuteScalarT Method (IDbConnection, String, Object, IDbTransaction, NullableInt32, NullableCommandType) |
Execute parameterized SQL that selects a single value
Namespace: DapperAssembly: VirtualRadar.Database (in VirtualRadar.Database.dll) Version: 1.0.0.0 (1.0.0.0)
Syntax public static T ExecuteScalar<T>(
this IDbConnection cnn,
string sql,
Object param = null,
IDbTransaction transaction = null,
Nullable<int> commandTimeout = null,
Nullable<CommandType> commandType = null
)
<ExtensionAttribute>
Public Shared Function ExecuteScalar(Of T) (
cnn As IDbConnection,
sql As String,
Optional param As Object = Nothing,
Optional transaction As IDbTransaction = Nothing,
Optional commandTimeout As Nullable(Of Integer) = Nothing,
Optional commandType As Nullable(Of CommandType) = Nothing
) As T
public:
[ExtensionAttribute]
generic<typename T>
static T ExecuteScalar(
IDbConnection^ cnn,
String^ sql,
Object^ param = nullptr,
IDbTransaction^ transaction = nullptr,
Nullable<int> commandTimeout = nullptr,
Nullable<CommandType> commandType = nullptr
)
[<ExtensionAttribute>]
static member ExecuteScalar :
cnn : IDbConnection *
sql : string *
?param : Object *
?transaction : IDbTransaction *
?commandTimeout : Nullable<int> *
?commandType : Nullable<CommandType>
(* Defaults:
let _param = defaultArg param null
let _transaction = defaultArg transaction null
let _commandTimeout = defaultArg commandTimeout null
let _commandType = defaultArg commandType null
*)
-> 'T
Parameters
- cnn
- Type: System.DataIDbConnection
- sql
- Type: SystemString
- param (Optional)
- Type: SystemObject
- transaction (Optional)
- Type: System.DataIDbTransaction
- commandTimeout (Optional)
- Type: SystemNullableInt32
- commandType (Optional)
- Type: SystemNullableCommandType
Type Parameters
- T
Return Value
Type:
TThe first cell selected
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