//private static string GetDatabaseFile(Repository repository) //{ // var dataPath = new DataPath(repository.Name); // var dataFile = Path.Combine(dataPath.PhysicalPath, repository.Name + ".mdf"); // return dataFile; //} //private static string GetIndividualDatabaseConnectionString(string connectionString, Repository repository) //{ // var connectionStringBuilder = new SqlConnectionStringBuilder(connectionString); // connectionStringBuilder.InitialCatalog = repository.Name; // return connectionStringBuilder.ConnectionString; //} //private static void CreateDatabase(Repository repository, string connectionString) //{ // var dataFile = GetDatabaseFile(repository); // var dir = Path.GetDirectoryName(dataFile); // IO.IOUtility.EnsureDirectoryExists(dir); // //do not specify the file path. // string sql = string.Format(@"CREATE DATABASE [{0}]" // , repository.Name // , Path.GetFileName(dataFile)); // SqlCommand command = new SqlCommand() { CommandText = sql }; // SQLServerHelper.ExecuteNonQuery(connectionString, command); //} // private static void DropDatabase(Repository repository, string connectionString) // { // string sql = string.Format(@"IF EXISTS(SELECT * FROM sys.databases WHERE name = '{0}') // DROP DATABASE {0}", repository.Name); // SqlCommand command = new SqlCommand() { CommandText = sql }; // SQLServerHelper.ExecuteNonQuery(connectionString, command); // } public static void DisposeDatabase(Repository repository) { SchemaManager.DropTable(repository, repository.GetCategoryTableName()); }
public override void Remove(Models.Schema item) { base.Remove(item); SchemaManager.Delete(item); }
public override void Initialize(Models.Schema schema) { SchemaManager.Add(schema); }
public override void Update(Models.Schema @new, Models.Schema old) { base.Update(@new, old); SchemaManager.Update(@new, old); }