/// <summary>
/// Creates a new DAORecordsetHelper object using the “factoryName”, “type”, "options", "lockType" and opens it by executing the query on the “SQLstr” using the connection object provided has parameter and load all results.
/// </summary>
/// <param name="SQLStr">The string containing the SQL query to be loaded into this DAORecodsetHelper object.</param>
/// <param name="type">The DAORecordsetTypeEnum of this DAORecordsetHelper object.</param>
/// <param name="options">The DAORecordsetOptionEnum of this DAORecordsetHelper object.</param>
/// <param name="lockType">The DAOLockTypeEnum of this DAORecordsetHelper object.</param>
/// <param name="connection">Connection object to be use by this DAORecordsetHelper.</param>
/// <param name="factoryName">The name of the factory to by use by this DAORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns>The new DAORecordsetHelper object.</returns>
public static DAORecordSetHelper Open(string SQLStr, DAORecordsetTypeEnum type, DAORecordsetOptionEnum options, DAOLockTypeEnum lockType, DbConnection connection, string factoryName)
{
DAORecordSetHelper recordSet = new DAORecordSetHelper(factoryName, type, options, lockType);
recordSet.Open(SQLStr, connection);
return(recordSet);
}
/// <summary>
/// Creates a new DAORecordsetHelper object using the “factoryName” and opens it by executing the query in the “command” parameter and load all results.
/// </summary>
/// <param name="command">A command containing the query to be execute to load the DAORecordsetHelper object.</param>
/// <param name="factoryName">The name of the factory to by use by this DAORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns>The new DAORecordsetHelper object.</returns>
public static DAORecordSetHelper Open(DbCommand command, String factoryName)
{
DAORecordSetHelper recordSet = new DAORecordSetHelper(factoryName);
recordSet.Open(command);
return(recordSet);
}
/// <summary>
/// Creates a new DAORecordsetHelper object using the “factoryName” and opens it by executing the query on the “SQLstr” using the connection object provided has parameter and load all results.
/// </summary>
/// <param name="SQLStr">The string containing the SQL query to be loaded into this DAORecodsetHelper object.</param>
/// <param name="connection">Connection object to be use by this DAORecordsetHelper.</param>
/// <param name="factoryName">The name of the factory to by use by this DAORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns></returns>
public static DAORecordSetHelper Open(string SQLStr, DbConnection connection, string factoryName)
{
DAORecordSetHelper recordSet = new DAORecordSetHelper(factoryName);
recordSet.Open(SQLStr, connection);
return(recordSet);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="factoryName"></param>
/// <returns></returns>
public DAORecordSetHelper OpenRecordset(string name, string factoryName)
{
DAORecordSetHelper rs = new DAORecordSetHelper(factoryName);
rs.ActiveConnection = _connection;
rs.Source = name;
rs.Open();
return(rs);
}
/// <summary>
/// Creates and open a new DAORecordsetHelper using the same information of the current object.
/// </summary>
/// <returns>A new DAORecordset.</returns>
public DAORecordSetHelper OpenRS()
{
DAORecordSetHelper newRecordSet = new DAORecordSetHelper();
newRecordSet.activeCommand = this.activeCommand;
newRecordSet.ActiveConnection = this.ActiveConnection;
newRecordSet.DatabaseType = this.DatabaseType;
newRecordSet.ProviderFactory = this.ProviderFactory;
newRecordSet.Open();
return(newRecordSet);
}
/// <summary>
/// Creates and open a new DAORecordsetHelper using the same information of the current object and the type provided has parameter.
/// </summary>
/// <param name="rsType">The DAORecordsetTypeEnum of this DAORecordsetHelper object.</param>
/// <param name="rsOptions">The DAORecordsetOptionEnum of this DAORecordsetHelper object.</param>
/// <returns>A new DAORecordset.</returns>
public DAORecordSetHelper OpenRS(DAORecordsetTypeEnum rsType, DAORecordsetOptionEnum rsOptions)
{
DAORecordSetHelper newRecordSet = new DAORecordSetHelper();
newRecordSet.daoRSType = rsType;
newRecordSet.daoRSOption = rsOptions;
newRecordSet.activeCommand = this.activeCommand;
newRecordSet.ActiveConnection = this.ActiveConnection;
newRecordSet.DatabaseType = this.DatabaseType;
newRecordSet.ProviderFactory = this.ProviderFactory;
newRecordSet.Open();
return(newRecordSet);
}
/// <summary>
/// Creates and open a new DAORecordsetHelper using the same information of the current object and the type provided has parameter.
/// </summary>
/// <param name="rsType">The DAORecordsetTypeEnum of this DAORecordsetHelper object.</param>
/// <param name="rsOptions">The DAORecordsetOptionEnum of this DAORecordsetHelper object.</param>
/// <returns>A new DAORecordset.</returns>
public DAORecordSetHelper OpenRS(DAORecordsetTypeEnum rsType, DAORecordsetOptionEnum rsOptions)
{
DAORecordSetHelper newRecordSet = new DAORecordSetHelper();
newRecordSet.daoRSType = rsType;
newRecordSet.daoRSOption = rsOptions;
newRecordSet.activeCommand = this.activeCommand;
newRecordSet.ActiveConnection = this.ActiveConnection;
newRecordSet.DatabaseType = this.DatabaseType;
newRecordSet.ProviderFactory = this.ProviderFactory;
newRecordSet.Open();
return newRecordSet;
}
/// <summary>
/// Creates and open a new DAORecordsetHelper using the same information of the current object.
/// </summary>
/// <returns>A new DAORecordset.</returns>
public DAORecordSetHelper OpenRS()
{
DAORecordSetHelper newRecordSet = new DAORecordSetHelper();
newRecordSet.activeCommand = this.activeCommand;
newRecordSet.ActiveConnection = this.ActiveConnection;
newRecordSet.DatabaseType = this.DatabaseType;
newRecordSet.ProviderFactory = this.ProviderFactory;
newRecordSet.Open();
return newRecordSet;
}
/// <summary>
/// Creates a new DAORecordsetHelper object using the “factoryName” and opens it by executing the query in the “command” parameter and load all results.
/// </summary>
/// <param name="command">A command containing the query to be execute to load the DAORecordsetHelper object.</param>
/// <param name="factoryName">The name of the factory to by use by this DAORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns>The new DAORecordsetHelper object.</returns>
public static DAORecordSetHelper Open(DbCommand command, String factoryName)
{
DAORecordSetHelper recordSet = new DAORecordSetHelper(factoryName);
recordSet.Open(command);
return recordSet;
}
/// <summary>
/// Creates a new DAORecordsetHelper object using the “factoryName”, “type”, "options", "lockType" and opens it by executing the query on the “SQLstr” using the connection object provided has parameter and load all results.
/// </summary>
/// <param name="SQLStr">The string containing the SQL query to be loaded into this DAORecodsetHelper object.</param>
/// <param name="type">The DAORecordsetTypeEnum of this DAORecordsetHelper object.</param>
/// <param name="options">The DAORecordsetOptionEnum of this DAORecordsetHelper object.</param>
/// <param name="lockType">The DAOLockTypeEnum of this DAORecordsetHelper object.</param>
/// <param name="connection">Connection object to be use by this DAORecordsetHelper.</param>
/// <param name="factoryName">The name of the factory to by use by this DAORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns>The new DAORecordsetHelper object.</returns>
public static DAORecordSetHelper Open(string SQLStr, DAORecordsetTypeEnum type, DAORecordsetOptionEnum options, DAOLockTypeEnum lockType, DbConnection connection, string factoryName)
{
DAORecordSetHelper recordSet = new DAORecordSetHelper(factoryName, type, options, lockType);
recordSet.Open(SQLStr, connection);
return recordSet;
}
/// <summary>
/// Creates a new DAORecordsetHelper object using the “factoryName” and opens it by executing the query on the “SQLstr” using the connection object provided has parameter and load all results.
/// </summary>
/// <param name="SQLStr">The string containing the SQL query to be loaded into this DAORecodsetHelper object.</param>
/// <param name="connection">Connection object to be use by this DAORecordsetHelper.</param>
/// <param name="factoryName">The name of the factory to by use by this DAORecordsetHelper object (the name most exist on the configuration xml file).</param>
/// <returns></returns>
public static DAORecordSetHelper Open(string SQLStr, DbConnection connection, string factoryName)
{
DAORecordSetHelper recordSet = new DAORecordSetHelper(factoryName);
recordSet.Open(SQLStr, connection);
return recordSet;
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="factoryName"></param>
/// <returns></returns>
public DAORecordSetHelper OpenRecordset(string name, string factoryName)
{
DAORecordSetHelper rs = new DAORecordSetHelper(factoryName);
rs.ActiveConnection = _connection;
rs.Source = name;
rs.Open();
return rs;
}