SqlExecutorExtensions Class

.NET Standard 2.x

Provides the extension methods for SqlExecutor.

Namespace: PowerScript.Bridge

Assembly: PowerScript.Bridge.dll

Syntax

  public static class SqlExecutorExtensions;

Methods

Name	Return Type	Description
ExecuteCursor(string sqlText, out DbResultSet resultSet, params object[] parameters)	void	Executes the SQL statement and returns the result set in a cursor.
ExecuteNonQuery(string sqlText, out SqlResult resultSet, params object[] parameters)	void	Executes a stored procedure which returns no result set.
ExecuteProcedure(string sqlText, out DbResultSet resultSet, params object[] parameters)	void	Executes a stored procedure which returns a result set.
Scalar<TValue>(string sqlText, out SqlResult resultSet, params object[] parameters)	TValue	Executes the SQL SELECT statement and returns the first column of the first row in the result set. All other columns and rows are ignored.
SelectOne(string sqlText, out SqlResult resultSet, params object[] parameters)	SnapObjects.Data.DynamicModel	Executes the SQL SELECT statement and returns the first row in the result set. All other rows are ignored.