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); }
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); long maxNum = 0; using (IDataReader reader = DatabaseConnection.CurrentConnection.LoadDataReader("select max(testautoincid) from testautoinc")) { while (reader.Read()) { maxNum = reader.GetInt64(0); } } Assert.AreEqual(maxNum, mockSupportsAutoIncrementingID.AutoValue); }