/// <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();
}
