public void LoadVersionedStoredProcedures(String dbName, String version)
{
var dbRepo = new DatabaseUtility.Schema.Repository.DbDatabaseSchemaRepository();
string activeDbName = dbName ?? System.Configuration.ConfigurationManager.AppSettings["ActiveDatabaseConnection"];
string activeVersion = version ?? System.Configuration.ConfigurationManager.AppSettings["ActiveDatabaseVersion"];
string dbRepoConnString = System.Configuration.ConfigurationManager.ConnectionStrings["DbRepository"].ToString();
dbRepo.RepositoryLocation = dbRepoConnString;
var scehma = dbRepo.LoadDatabaseSchema(activeDbName, new DatabaseVersion(activeVersion));
VersionedStoredProcedures = scehma.StoredProcedures;
}
public void Can_Save_To_Repository()
{
DatabaseSchema databaseSchema = new DatabaseSchema();
databaseSchema.Name = "TestDB";
databaseSchema.Version = new DatabaseVersion(0, 0, 0, 1);
var schemaMetadata = new DatabaseUtility.Metadata.SchemaMetadata();
databaseSchema.StoredProcedures = schemaMetadata.GetStoredProcedures();
var repository = new DatabaseUtility.Schema.Repository.DbDatabaseSchemaRepository();
repository.RepositoryLocation = System.Configuration.ConfigurationManager.ConnectionStrings["DbRepository"].ConnectionString;
repository.SaveDatabaseSchema(databaseSchema);
}
public void Saved_DatabaseSchema_Equivalent_To_Loaded()
{
DatabaseSchema original = new DatabaseSchema();
original.Name = "TestDB";
original.Version = new DatabaseVersion(0, 0, 0, 1);
var schemaMetadata = new DatabaseUtility.Metadata.SchemaMetadata();
original.StoredProcedures = schemaMetadata.GetStoredProcedures();
var saveRepository = new DatabaseUtility.Schema.Repository.DbDatabaseSchemaRepository();
saveRepository.RepositoryLocation = System.Configuration.ConfigurationManager.ConnectionStrings["DbRepository"].ConnectionString;
saveRepository.SaveDatabaseSchema(original);
var loadRepository = new DatabaseUtility.Schema.Repository.DbDatabaseSchemaRepository();
loadRepository.RepositoryLocation = System.Configuration.ConfigurationManager.ConnectionStrings["DbRepository"].ConnectionString;
var loaded = loadRepository.LoadDatabaseSchema("TestDB", new DatabaseVersion(0, 0, 0, 1));
DatabaseSchemaAssertions.DatabaseSchemasAreEquivalent(original, loaded);
}
public void Can_Load_From_Repository()
{
var repository = new DatabaseUtility.Schema.Repository.DbDatabaseSchemaRepository();
repository.RepositoryLocation = System.Configuration.ConfigurationManager.ConnectionStrings["DbRepository"].ConnectionString;
var databaseSchema = repository.LoadDatabaseSchema("TestDB", new DatabaseVersion(0, 0, 0, 1));
}
