Interface IConnection

An interface implemented by objects that can be Connections. A Connection provides a method for testing to see if a connection to the underlying database can be made, and provides the ability to execute a sql statement against that database.


public abstract interface IConnection

Interface Members

MemberDescription

UpdateProgress

Raised as records are retrieved from the database.

ExecuteSQLStatement

Executes the passed-in SQL Statement against this connection.

public DataTable ExecuteSQLStatement(object query,
    string tablename,
    IReport report);

public DataTable ExecuteSQLStatement(string query,
    Object[] parameters,
    string tablename,
    IReport report);

ExecuteStoredProcedure

Executes the specified stored procedure against this connection.

public DataTable ExecuteStoredProcedure(string name,
    List<IParameter> parameters,
    string tablename,
    IReport report);

GetConnection

Returns an IDbConnection object with ConnectionString set to the correct value.

public IDbConnection GetConnection();

GetStoredProcedureParameters

Get the parameters for the specified stored procedure.

public DbParameterCollection GetStoredProcedureParameters(string name);

GetStoredProcedureSchema

Get the schema of the specified stored procedure.

public DataTable GetStoredProcedureSchema(string name);

TestConnection

Tests the connection.

public bool TestConnection();

CommandTimeout

The timeout to use for commands.

ConnectionTimeout

The timeout to use for the connection.

Datasource

The data source this connection is linked to

Error

The message of any error that occurs during connection or data retrieval.

Requirements

Namespace: Stonefield.Query.ConnectionManagement
Assembly: interfaces.dll