public List <Year> GetAllYears() { string connectionString = Utility.Util.GetConnectionString(MoviesStore.Service.Common.Util.MasterDataManager.ConfigData["MoviesStoreDb"]); string providerName = Utility.Util.GetProviderName(MoviesStore.Service.Common.Util.MasterDataManager.ConfigData["MoviesStoreDb"]); string spName = MoviesStore.Service.Common.Util.MasterDataManager.ConfigData["GetAllYears"]; try { return(_masterRepository.GetAllYears(spName, providerName, connectionString)); } catch (Exception e) { throw e.InnerException; } }