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);
}
