Class Connection

Abstract base class for specific connections.

System.Object
  Stonefield.Query.ConnectionManagement.Connection
public abstract class Connection : object, IConnection

Class Members

MemberDescription

UpdateProgress

Raised as records are retrieved from the database.

ExecuteSQLStatement

Executes the passed-in SQL Statement against this connection.

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

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

ExecuteStoredProcedure

Executes the specified stored procedure against this connection.

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

GetConnection

Returns an IDbConnection object with ConnectionString and ConnectionTimeout set to the correct values.

public abstract IDbConnection GetConnection();

GetStoredProcedureParameters

Get the parameters for the specified stored procedure.

public abstract DbParameterCollection GetStoredProcedureParameters(string name);

GetStoredProcedureSchema

Get the schema of the specified stored procedure.

public sealed DataTable GetStoredProcedureSchema(string name);

TestConnection

Tests the connection.

public virtual bool TestConnection();

CommandTimeout

The timeout to use for commands.

ConnectionTimeout

The timeout to use for the connection.

Datasource

The data source this factory is linked to

Error

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

OutputHelper

The output helper for this connection.

SQLStatement

The SQL statement object.

Requirements

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