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