Class SQOleDbConnection

This class represents a connection to a database using an OleDb provider.

System.Object
  Stonefield.Query.ConnectionManagement.Connection
    Stonefield.Query.ConnectionManagement.SQOleDbConnection
public class SQOleDbConnection : Connection

Class Members

MemberDescription

ExecuteSQLStatement

Executes the passed-in SQL Statement against this connection.

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

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

ExecuteStoredProcedure

Executes the passed-in stored procedure against this connection.

public virtual 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 virtual IDbConnection GetConnection();

GetStoredProcedureParameters

Get the parameters for the specified stored procedure.

public virtual DbParameterCollection GetStoredProcedureParameters(string name);

Requirements

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