private void WriteMetaDataInCHM() { SetStatus("Writing Columns..."); ColumnsHelper.WriteColumns(); backgroundWorker2.ReportProgress(5, ObjectTypes.Columns); SetStatus("Writing ForeignKeys..."); ForeignKeysHelper.WriteForeignKeys(); backgroundWorker2.ReportProgress(10, ObjectTypes.ForeignKeys); SetStatus("Writing IndexColumns..."); IndexColumnsHelper.WriteIndexColumns(); backgroundWorker2.ReportProgress(15, ObjectTypes.IndexColumns); SetStatus("Writing Indexes..."); IndexesHelper.WriteIndexes(); backgroundWorker2.ReportProgress(20, ObjectTypes.Indexes); SetStatus("Writing Tables..."); TablesHelper.WriteTables(); backgroundWorker2.ReportProgress(25, ObjectTypes.Tables); SetStatus("Writing ViewColumns..."); ViewColumnsHelper.WriteViewColumns(); backgroundWorker2.ReportProgress(30, ObjectTypes.ViewColumns); SetStatus("Writing Views..."); ViewsHelper.WriteViews(); backgroundWorker2.ReportProgress(35, ObjectTypes.Views); SetStatus("Writing ProcedureParameters..."); ProcedureParametersHelper.WriteProcedureParameters(); backgroundWorker2.ReportProgress(40, ObjectTypes.ProcedureParameters); SetStatus("Writing Procedures..."); ProceduresHelper.WriteProcedures(); backgroundWorker2.ReportProgress(45, ObjectTypes.Procedures); SetStatus("Writing Triggers..."); SMOHelper.TriggersHelper.WriteTriggers(); backgroundWorker2.ReportProgress(50, ObjectTypes.Triggers); SetStatus("Writing UserDefinedDataTypes..."); SMOHelper.UserDefinedDataTypesHelper.WriteUserDefinedDataTypes(); backgroundWorker2.ReportProgress(55, ObjectTypes.UserDefinedDataTypes); SetStatus("Writing InstanceInformation..."); InstanceInformationHelper.WriteInstanceInformation(); backgroundWorker2.ReportProgress(60, ObjectTypes.InstanceInformation); SetStatus("Writing DataSourceInformation..."); DataSourceInformationHelper.WriteDataSourceInformation(); backgroundWorker2.ReportProgress(65, ObjectTypes.DataSourceInformation); SetStatus("Writing DataTypes..."); DataTypesHelper.WriteDataTypes(); backgroundWorker2.ReportProgress(70, ObjectTypes.DataTypes); SetStatus("Writing Restrictions..."); RestrictionsHelper.WriteRestrictions(); backgroundWorker2.ReportProgress(75, ObjectTypes.Restrictions); SetStatus("Writing ReservedWords..."); ReservedWordsHelper.WriteReservedWords(); backgroundWorker2.ReportProgress(80, ObjectTypes.ReservedWords); SetStatus("Writing Users..."); UsersHelper.WriteUsers(); backgroundWorker2.ReportProgress(85, ObjectTypes.Users); }
private void GetMetaData() { SetStatus("Fetching Columns..."); ColumnsHelper.GetColumns(); backgroundWorker1.ReportProgress(5, ObjectTypes.Columns); SetStatus("Fetching ForeignKeys..."); ForeignKeysHelper.GetForeignKeys(); backgroundWorker1.ReportProgress(10, ObjectTypes.ForeignKeys); SetStatus("Fetching IndexColumns..."); IndexColumnsHelper.GetIndexColumns(); backgroundWorker1.ReportProgress(15, ObjectTypes.IndexColumns); SetStatus("Fetching Indexes..."); IndexesHelper.GetIndexes(); backgroundWorker1.ReportProgress(20, ObjectTypes.Indexes); SetStatus("Fetching Tables..."); TablesHelper.GetTables(); backgroundWorker1.ReportProgress(25, ObjectTypes.Tables); SetStatus("Fetching ViewColumns..."); ViewColumnsHelper.GetViewColumns(); backgroundWorker1.ReportProgress(30, ObjectTypes.ViewColumns); SetStatus("Fetching Views..."); ViewsHelper.GetViews(); backgroundWorker1.ReportProgress(35, ObjectTypes.Views); SetStatus("Fetching ProcedureParameters..."); ProcedureParametersHelper.GetProcedureParameters(); backgroundWorker1.ReportProgress(40, ObjectTypes.ProcedureParameters); SetStatus("Fetching Procedures..."); ProceduresHelper.GetProcedures(); backgroundWorker1.ReportProgress(45, ObjectTypes.Procedures); SetStatus("Fetching Triggers..."); SMOHelper.TriggersHelper.GetTriggers(Utility.DatabaseName); backgroundWorker1.ReportProgress(50, ObjectTypes.Triggers); SetStatus("Fetching UserDefinedDataTypes..."); SMOHelper.UserDefinedDataTypesHelper.GetUserDefinedDataTypes(Utility.DatabaseName); backgroundWorker1.ReportProgress(55, ObjectTypes.UserDefinedDataTypes); SetStatus("Fetching InstanceInformation..."); InstanceInformationHelper.GetInstanceInformation(); backgroundWorker1.ReportProgress(60, ObjectTypes.InstanceInformation); SetStatus("Fetching DataSourceInformation..."); DataSourceInformationHelper.GetDataSourceInformation(); backgroundWorker1.ReportProgress(65, ObjectTypes.DataSourceInformation); SetStatus("Fetching DataTypes..."); DataTypesHelper.GetDataTypes(); backgroundWorker1.ReportProgress(70, ObjectTypes.DataTypes); SetStatus("Fetching Restrictions..."); RestrictionsHelper.GetRestrictions(); backgroundWorker1.ReportProgress(75, ObjectTypes.Restrictions); SetStatus("Fetching ReservedWords..."); ReservedWordsHelper.GetReservedWords(); backgroundWorker1.ReportProgress(80, ObjectTypes.ReservedWords); SetStatus("Fetching Users..."); UsersHelper.GetUsers(); backgroundWorker1.ReportProgress(85, ObjectTypes.Users); }