DatabaseConnection
Creates database connection instances.
Opens a database connection and starts a database transaction.
Commits the database transaction.
public DataSet ExecuteAsDataSet(string sqlStatement, SqlParameter[] parameters = null, int timeoutValue = -1)
Executes a Transact-SQL statement against the connection and returns a dataset object.
public object ExecuteAsScalar(string sqlStatement, SqlParameter[] parameters = null, int timeoutValue = -1)
Executes the query, and returns the first column of the first row in the result set returned by the query. Additional columns or rows are ignored.
public int ExecuteNonQuery(string sqlStatement, SqlParameter[] parameters = null, int timeoutValue = -1)
Executes a Transact-SQL statement against the connection and returns the number of rows affected.
Returns a prepend string value for a given case database based on application ID.
Returns a prepend string value for a given case database based on application ID and a Boolean flag indicating whether the schema name should be used.
Returns a prepend string value for a master database.
Returns a prepend string value for a master database based on boolean flag indicating if schema name should be used.
Rolls back a database transaction from a pending state.