/// <summary> /// Executes a Query SQL Command against the database and returns the scalar result (first column of first row of the result) /// </summary> /// <param name="sqlCmd">SQL Command</param> /// <returns>First Column of First Row of the Results</returns> public override object ExecuteScalar(string sqlCmd) { //Get Thread ID int thread = Thread.CurrentThread.ManagedThreadId; //Create the SQL Command VirtuosoCommand cmd = new VirtuosoCommand(sqlCmd, this._dbConnections[thread]); if (this._dbTrans[thread] != null) { //Add to the Transaction if required cmd.Transaction = this._dbTrans[thread]; } //Execute the Scalar return cmd.ExecuteScalar(); }
/// <summary> /// Executes a Query SQL Command against the database and returns the scalar result (first column of first row of the result) /// </summary> /// <param name="sqlCmd">SQL Command</param> /// <returns>First Column of First Row of the Results</returns> public object ExecuteScalar(string sqlCmd) { //Create the SQL Command VirtuosoCommand cmd = new VirtuosoCommand(sqlCmd, this._db); if (this._dbtrans != null) { //Add to the Transaction if required cmd.Transaction = this._dbtrans; } //Execute the Scalar return cmd.ExecuteScalar(); }