<PackageReference Include="Relativity.Server.EventHandler.SDK" Version="17.4.2" />

DatabaseConnection

public class DatabaseConnection : MarshalByRefObject
Creates database connection instances.
public void BeginTransaction()

Opens a database connection and starts a database transaction.

public void CommitTransaction()

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.

public string GetCaseDatabasePrependString(int appID)

Returns a prepend string value for a given case database based on application ID.

public string GetCaseDatabasePrependString(int appID, bool useSchemaName)

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.

public string GetMasterPrependString()

Returns a prepend string value for a master database.

public string GetMasterPrependString(bool useSchemaName)

Returns a prepend string value for a master database based on boolean flag indicating if schema name should be used.

public void RollbackTransaction()

Rolls back a database transaction from a pending state.