IDataAccessAdapterFetchScalarQueryAsyncT Method (CancellationToken, PlainSQLFetchAspects, String, Object)

Async variant of FetchScalarQueryT(PlainSQLFetchAspects, String, Object). Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Namespace: SD.LLBLGen.Pro.ORMSupportClasses
Assembly: SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.4.0.0 (5.4.0)

Syntax

Copy

Task<T> FetchScalarQueryAsync<T>(
	CancellationToken cancellationToken,
	PlainSQLFetchAspects fetchAspects,
	string sqlQuery,
	Object parameterValues = null
)

Function FetchScalarQueryAsync(Of T) ( 
	cancellationToken As CancellationToken,
	fetchAspects As PlainSQLFetchAspects,
	sqlQuery As String,
	Optional parameterValues As Object = Nothing
) As Task(Of T)

Parameters

cancellationToken: Type: System.ThreadingCancellationToken
the cancellationToken
fetchAspects: Type: SD.LLBLGen.Pro.ORMSupportClassesPlainSQLFetchAspects
The fetch aspects for this query. Can be null, in which case the defaults are used.
sqlQuery: Type: SystemString
The SQL query to execute, which returns a scalar value. Should contain parameter names for the parameter values, or placeholders for parameter sets. See documentation for details regarding format specifics.
parameterValues (Optional): Type: SystemObject
The object containing the parameter values to use in the query. If it's an object array, parameters using ordening are assumed, otherwise for each public, non-static property, a parameter is created.

Type Parameters

T: The type of the scalar value to return.

Return Value

Type: TaskT
The first scalar value returned by the query as an instance of T or null if the query returned a NULL.

Reference

IDataAccessAdapter Interface

FetchScalarQueryAsync Overload

SD.LLBLGen.Pro.ORMSupportClasses Namespace