/// <summary>
/// Initialises the sql statement with a autoincrementing object
/// </summary>
private void InitialiseStatement(string tableName, ISupportsAutoIncrementingField supportsAutoIncrementingField)
{
_dbFieldList = new StringBuilder(_bo.Props.Count * 20);
_dbValueList = new StringBuilder(_bo.Props.Count * 20);
var statement = new InsertSqlStatement(_connection);
statement.TableName = tableName;
statement.SupportsAutoIncrementingField = supportsAutoIncrementingField;
_insertSql = statement;
_gen = _connection.CreateParameterNameGenerator();
_firstField = true;
}
/// <summary>
/// Constructor to initialise a new sql statement
/// </summary>
/// <param name="connection">A database connection</param>
public SqlStatement(IDatabaseConnection connection)
{
if (connection == null) throw new ArgumentNullException("connection");
_parameters = new List<IDbDataParameter>();
DatabaseConnection = connection;
_idbConnection = DatabaseConnection.GetConnection();
if (_idbConnection != null)
{
_sampleCommand = _idbConnection.CreateCommand();
_gen = connection.CreateParameterNameGenerator();
}
else
{
_gen = new ParameterNameGenerator(null);
}
_statement = new StringBuilder(100);
}
/// <summary>
/// Constructor to initialise a new sql statement
/// </summary>
/// <param name="connection">A database connection</param>
public SqlStatement(IDatabaseConnection connection)
{
if (connection == null)
{
throw new ArgumentNullException("connection");
}
_parameters = new List <IDbDataParameter>();
DatabaseConnection = connection;
_idbConnection = DatabaseConnection.GetConnection();
if (_idbConnection != null)
{
_sampleCommand = _idbConnection.CreateCommand();
_gen = connection.CreateParameterNameGenerator();
}
else
{
_gen = new ParameterNameGenerator(null);
}
_statement = new StringBuilder(100);
}