public void Test05UpdateThenCompare()
{
var connString = "Data Source=" + AppPath + TEMP_FILENAME + "; Persist Security Info=False;";
var SqlVerify = new SqlVerify(new SqlVerifyConfiguration(new SqlCeConnectionFactory(connString)));
SqlVerify.UpdateDb();
Assert.IsTrue(SqlVerify.VerifyDb());
}
public void Test02NoChangeSameHash()
{
var connString = "Data Source=" + AppPath + TEMP_FILENAME + "; Persist Security Info=False;";
var SqlVerify = new SqlVerify(new SqlVerifyConfiguration(new SqlCeConnectionFactory(connString)));
var hash = SqlVerify.BuildSchemaHash();
var hash2 = SqlVerify.BuildSchemaHash();
Assert.AreEqual(hash, hash2, "differing hash with no SQL change");
}
public void Test03ChangeSchemaChangeHash()
{
var connString = "Data Source=" + AppPath + TEMP_FILENAME + "; Persist Security Info=False;";
var SqlVerify = new SqlVerify(new SqlVerifyConfiguration(new SqlCeConnectionFactory(connString)));
var hash = SqlVerify.BuildSchemaHash();
// make a change to the schema
using (var conn = SqlVerify.Configuration.ConnectionFactory.GetConnection())
{
conn.Open();
var command = conn.CreateCommand();
command.CommandText = "ALTER TABLE [Customers] ADD COLUMN [Mobile] NVARCHAR NULL;";
command.ExecuteNonQuery();
}
var hash2 = SqlVerify.BuildSchemaHash();
Assert.AreNotEqual(hash, hash2, "hash values equal after schema change");
}
public void Test06UpdateChangeCompare()
{
var connString = "Data Source=" + AppPath + TEMP_FILENAME + "; Persist Security Info=False;";
var SqlVerify = new SqlVerify(new SqlVerifyConfiguration(new SqlCeConnectionFactory(connString)));
SqlVerify.UpdateDb();
// make a change to the schema
using (var conn = SqlVerify.Configuration.ConnectionFactory.GetConnection())
{
conn.Open();
var command = conn.CreateCommand();
command.CommandText = "ALTER TABLE [Customers] ADD COLUMN [WorkPhone] NVARCHAR NULL;";
command.ExecuteNonQuery();
}
Assert.IsFalse(SqlVerify.VerifyDb());
}
