Instantiate a new DataServer using the supplied connection string

Instantiate a new DataServer using the connection string associated with the IiMISUser object sent in as a parameter.

Starts a database transaction. Any other database operations performed using this instance of the DataServer will be in the same transaction until a CommitTransaction()()()() or RollbackTransaction()()()() is called.

Binds the supplied parameters to the supplied command and executes the command. The command must have been prepared with a call to PrepareCommand(SqlCommand, CommandType, String, array<SqlParameter>[]()[][]). This method can then be called in a loop with different parameters to save the prepare time when the same statement is executed over and over.

Closes the connection to the database if it is open. If there is no open Connection no harm is done by calling this method. If there is an open connection and there is also an open transaction the transaction will be rolled back before the connection is closed.

If there is an open transaction associated with this DataServer instance, it will be committed. If there is no open transaction no harm is done by calling this method.

Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.

Rolls back and open transaction and closes any open connection

Determines whether the specified Object is equal to the current Object.

Executes the SQL query in the sql parameter against the database. Use this method when the sql query does not return a result set (e.g., INSERT, UPDATE, or some stored procs). Otherwise, use ExecuteQuery(CommandType, String) if a result set is desired.

Executes the SQL query in the sql parameter against the database. Use this method when the sql query does not return a result set (e.g., INSERT, UPDATE, or some stored procs). Otherwise, use ExecuteQuery(CommandType, String, array<SqlParameter>[]()[][]) if a result set is desired.

Executes the SQL query in the sql parameter against the database. Use this method when the sql query returns a result set (e.g., SELECT or some stored procs). Otherwise, use ExecuteNonQuery(CommandType, String).

Executes the SQL query in the sql parameter against the database. Use this method when the sql query returns a result set (e.g., SELECT or some stored procs). Otherwise, use ExecuteNonQuery(CommandType, String, array<SqlParameter>[]()[][]).

Executes the SQL query in the sql parameter against the database. Use this method when the sql query returns a result set (e.g., SELECT or some stored procs). Otherwise, use ExecuteNonQuery(CommandType, String).

Executes the SQL query in the sql parameter against the database. Use this method when the sql query returns a result set (e.g., SELECT or some stored procs). Otherwise, use ExecuteNonQuery(CommandType, String, array<SqlParameter>[]()[][]).

Executes the query, and returns the first column of the first row in the resultset returned by the query. Extra columns or rows are ignored.

Destructor

Serves as a hash function for a particular type.

Retrieves the current lifetime service object that controls the lifetime policy for this instance.

Gets the Type of the current instance.

Obtains a lifetime service object to control the lifetime policy for this instance.

Creates a shallow copy of the current Object.

Creates a shallow copy of the current MarshalByRefObject object.

Prepares a SQL command to be executed. This should not normally be called outside of this class but is public in case the same statement needs to be executed over and over with different bind variables.

If there is an open transaction associated with this DataServer instance, all statements executed within that transaction will be rolled back (discarded). If there is no open transaction no harm is done by calling this method.

Returns a String that represents the current Object.

Gets the current SqlConnection to the database.

Gets an indication of whether or not the DataServer instance has an open transaction