/// <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;
}
public void TestAutoIncrementAfterInsert()
{
// MockRepository mockRepository = new MockRepository();
MockSupportsAutoIncrementingID mockSupportsAutoIncrementingID = new MockSupportsAutoIncrementingID();
InsertSqlStatement sql = new InsertSqlStatement(DatabaseConnection.CurrentConnection, "insert into testautoinc (testfield) values ('testing')");
sql.TableName = "testautoinc";
sql.SupportsAutoIncrementingField = mockSupportsAutoIncrementingID;
DatabaseConnection.CurrentConnection.ExecuteSql(sql);
int maxNum = 0;
using (IDataReader reader = DatabaseConnection.CurrentConnection.LoadDataReader("select max(testautoincid) from testautoinc"))
{
while (reader.Read())
{
maxNum = reader.GetInt32(0);
}
}
Assert.AreEqual(maxNum, mockSupportsAutoIncrementingID.AutoValue);
}
/// <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;
}
