public static void CreateObject(SqlConnection connection, string sqlScript, string objectName)
{
// Create the object
ExecuteScript(connection, sqlScript);
// Verify that the object was created
DatabaseAssert.ObjectExists(connection, objectName);
}
public static void DropDatabase(SqlConnection connection, string databaseName)
{
// Drop the database
ExecuteScript(connection, String.Format(DataResources.DropDatabase, DataTestHelper.DatabaseName));
//Verify that database was dropped
DatabaseAssert.DatabaseDoesNotExist(connection, databaseName);
}
public static void CreateDatabase(SqlConnection connection, string databaseName)
{
// Create the database
ExecuteScript(connection, String.Format(DataResources.CreateDatabase, databaseName));
//Verify that database was created
DatabaseAssert.DatabaseExists(connection, databaseName);
}
public static void EmptyTable(SqlConnection connection, string tableName)
{
string clearContentItems = String.Format(RemoveTokens(DataResources.EmptyTable), tableName);
ExecuteScript(connection, clearContentItems);
// Verify that the table is empty
DatabaseAssert.TableIsEmpty(connection, tableName);
}