Click or drag to resize

AdoDataConnectionExecuteScalarT(T, Int32, String, Object) Method

Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T, substituting defaultValue if Value is retrieved.

Namespace: GSF.Data
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta
Syntax
public T ExecuteScalar<T>(
	T defaultValue,
	int timeout,
	string sqlFormat,
	params Object[] parameters
)
View Source

Parameters

defaultValue  T
The value to be substituted if Value is retrieved.
timeout  Int32
The time in seconds to wait for the SQL statement to execute.
sqlFormat  String
Format string for the SQL statement to be executed.
parameters  Object
The parameter values to be used to fill in IDbDataParameter parameters.

Type Parameters

T

Return Value

T
Value in the first column of the first row in the result set.
See Also