/// <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; }