private static string GetFilesInFileGroup2008(FileGroup filegroup) { StringBuilder sql = new StringBuilder(); sql.Append("select file_id,type,name,physical_name,size,max_size,growth,is_sparse,is_percent_growth "); sql.Append("from sys.database_files WHERE data_space_id = " + filegroup.Id.ToString()); return sql.ToString(); }
public static string GetFilesInFileGroup(DatabaseInfo.VersionNumber version, FileGroup filegroup) { if (version == DatabaseInfo.VersionNumber.SQLServer2000) return GetFilesInFileGroup2000(filegroup); if (version == DatabaseInfo.VersionNumber.SQLServer2005) return GetFilesInFileGroup2005(filegroup); if (version == DatabaseInfo.VersionNumber.SQLServer2008) return GetFilesInFileGroup2008(filegroup); return ""; }
private static string GetFilesInFileGroup2000(FileGroup filegroup) { StringBuilder sql = new StringBuilder(); sql.Append("select convert(int,fileid) as file_id,type=convert(tinyint,(status&64)/64),name,filename as physical_name,size,maxsize as max_size,growth,convert(bit,0) as is_sparse,is_percent_growth =convert(bit,status & 1048576) "); sql.Append("FROM sysfiles where groupid="+filegroup.Id.ToString()); return sql.ToString(); }
private static void FillFiles(FileGroup filegroup, string connectionString) { using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand(GetSQLFile(filegroup), conn)) { conn.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { FileGroupFile item = new FileGroupFile(filegroup); item.Id = (int)reader["file_id"]; item.Name = reader["name"].ToString(); item.Owner = ""; item.Growth = (int)reader["growth"]; item.IsPercentGrowth = (bool)reader["is_percent_growth"]; item.IsSparse = (bool)reader["is_sparse"]; item.MaxSize = (int)reader["max_size"]; item.PhysicalName = reader["physical_name"].ToString(); item.Size = (int)reader["size"]; item.Type = (byte)reader["type"]; filegroup.Files.Add(item); } } } } }
public void Fill(Database database, string connectionString) { try { if (database.Options.Ignore.FilterTableFileGroup) { using (SqlConnection conn = new SqlConnection(connectionString)) { using (SqlCommand command = new SqlCommand(GetSQL(), conn)) { conn.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { FileGroup item = new FileGroup(database); item.Id = (int)reader["ID"]; item.Name = reader["name"].ToString(); item.Owner = ""; item.IsDefaultFileGroup = (bool)reader["is_default"]; item.IsReadOnly = (bool)reader["is_read_only"]; item.IsFileStream = reader["type"].Equals("FD"); FillFiles(item,connectionString); database.FileGroups.Add(item); } } } } } } catch { throw; } }
public static Boolean Compare(FileGroup origen, FileGroup destino) { if (destino == null) throw new ArgumentNullException("destino"); if (origen == null) throw new ArgumentNullException("origen"); if (origen.IsReadOnly != destino.IsReadOnly) return false; if (origen.IsDefaultFileGroup != destino.IsDefaultFileGroup) return false; if (origen.IsFileStream != destino.IsFileStream) return false; return true; }
/// <summary> /// Clona el objeto FileGroups en una nueva instancia. /// </summary> public FileGroupFiles Clone(FileGroup parentObject) { FileGroupFiles columns = new FileGroupFiles(parentObject); for (int index = 0; index < this.Count; index++) { columns.Add((FileGroupFile)this[index].Clone(parentObject)); } return(columns); }
public override ISchemaBase Clone(ISchemaBase parent) { FileGroup file = new FileGroup(parent); file.IsDefaultFileGroup = this.IsDefaultFileGroup; file.IsReadOnly = this.IsReadOnly; file.Name = this.Name; file.Id = this.Id; file.Files = this.Files.Clone(file); file.Guid = this.Guid; file.IsFileStream = this.IsFileStream; return file; }
public override ISchemaBase Clone(ISchemaBase parent) { FileGroup file = new FileGroup(parent); file.IsDefaultFileGroup = this.IsDefaultFileGroup; file.IsReadOnly = this.IsReadOnly; file.Name = this.Name; file.Id = this.Id; file.Files = this.Files.Clone(file); file.Guid = this.Guid; file.IsFileStream = this.IsFileStream; return(file); }
public static Boolean Compare(FileGroup origen, FileGroup destino) { if (destino == null) { throw new ArgumentNullException("destino"); } if (origen == null) { throw new ArgumentNullException("origen"); } if (origen.IsReadOnly != destino.IsReadOnly) { return(false); } if (origen.IsDefaultFileGroup != destino.IsDefaultFileGroup) { return(false); } if (origen.IsFileStream != destino.IsFileStream) { return(false); } return(true); }
private static string GetSQLFile(FileGroup filegroup) { string sql; sql = "select file_id,"; sql += "type,"; sql += "name,"; sql += "physical_name,"; sql += "size,"; sql += "max_size,"; sql += "growth,"; sql += "is_sparse,"; sql += "is_percent_growth "; sql += "from sys.database_files WHERE data_space_id = " + filegroup.Id.ToString(); return sql; }
/// <summary> /// Constructor de la clase. /// </summary> /// <param name="parent"> /// Objeto Database padre. /// </param> public FileGroupFiles(FileGroup parent) { this.Parent = parent; }