public void LoadList() { if (ModuleConfig.StorageType == StorageType.MySql) { AppSetting.CreateMySqlTableIfNotExists(); var query = @"SELECT * FROM `tmodule_app_settings`"; Task.Factory.StartNew(() => { return(Query.ExecuteMySql(query).Rows); }).ContinueWith((rows) => { Parallel.ForEach(rows.Result.Cast <DataRow>(), (row) => { dictionaries.AddAppSetting(new AppSetting { Id = Convert.ToInt32(row["id"].ToString()), Name = row["settings_name"].ToString(), Value = row["settings_value"].ToString() }); }); }).Wait(); // foreach (DataRow row in Query.ExecuteMySql(query).Rows) // { // AppSettings.Add(new AppSetting // { // Id = Convert.ToInt32(row["id"].ToString()), // Name = row["settings_name"].ToString(), // Value = row["settings_value"].ToString() // }); // } } IsLoaded = true; }