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.XmlDatabaseSchemaRepository();
     repository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
     repository.SaveDatabaseSchema(databaseSchema);
 }
 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 Can_Save_To_Repository()
 {
     DatabaseSchema databaseSchema = new DatabaseSchema();
     databaseSchema.Name = "Compass";
     databaseSchema.Version = new DatabaseVersion(0,0,0,1);
     var schemaMetadata = new DatabaseUtility.Metadata.SchemaMetadata();
     databaseSchema.StoredProcedures = schemaMetadata.GetStoredProcedures(new System.String[] { "p_AppointmentType_Select", "p_AppointmentType_Insert", "p_AppointmentType_Update" });
     var repository = new DatabaseUtility.Schema.Repository.DirectoryDatabaseSchemaRepository();
     repository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository";
     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.XmlDatabaseSchemaRepository();
            saveRepository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
            saveRepository.SaveDatabaseSchema(original);

            var loadRepository = new DatabaseUtility.Schema.Repository.XmlDatabaseSchemaRepository();
            loadRepository.RepositoryLocation = @"C:\Test\DatabaseSchemaRepository.xml";
            var loaded = loadRepository.LoadDatabaseSchema("TestDB", new DatabaseVersion(0, 0, 0, 1));

            DatabaseSchemaAssertions.DatabaseSchemasAreEquivalent(original, loaded);
        }
        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 abstract void SaveDatabaseSchema(DatabaseSchema databaseSchema);