public Dictionary <string, string> GetDataListSoldToActiveTranslation() { Dictionary <string, string> dictDataSourcesTranslated = new Dictionary <string, string>(); using (SystemEntities se = new SystemEntities()) { try { se.CommandTimeout = 0; var dataSourceResult = se.spDA_SoldToActiveDataSource_sel().ToList(); foreach (var item in dataSourceResult) { dictDataSourcesTranslated.Add(item.sold_data_source_id.Trim(), item.main_data_source_id.Trim()); } } catch (Exception ex) { } } return(dictDataSourcesTranslated); }