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