Platform Core .NET Assemblies API
ExecuteScalar<TResult>(String,QueryParameterCollection) Method
See Also Send Feedback

Terrasoft.DB.PostgreSql Namespace > PostgreSqlExecutor Class > ExecuteScalar Method : ExecuteScalar<TResult>(String,QueryParameterCollection) Method

sqlText: SQL command text.

queryParameters: Query parameters that will be converted into System.Data.Common.DbParameterCollection.

Executes a SQL statement with parameters, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.

Syntax

public override TResult ExecuteScalar<TResult>( 
   System.string sqlText,
   QueryParameterCollection queryParameters
)

Parameters

sqlText: SQL command text.
queryParameters: Query parameters that will be converted into System.Data.Common.DbParameterCollection.

Type Parameters

TResult

Return Value

Scalar value of the given result type.

Exceptions

Exception	Description
PostgreSqlExecutorException	Executor was created in another thread.

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2