Class SQMySqlConnection

This class represents a connection to a database using a MySql provider.

System.Object
  Stonefield.Query.ConnectionManagement.Connection
    Stonefield.Query.ConnectionManagement.SQMySqlConnection
public class SQMySqlConnection : 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 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. Note that SqlCe doesn't support stored procedures so this method throws an exception.

public virtual DbParameterCollection GetStoredProcedureParameters(string name)

Requirements

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