TrainNotifier.Service.TiplocRepository.GetTiplocsByStanox C# (CSharp) Method

        public IEnumerable<TiplocCode> GetTiplocsByStanox(string stanox)
        {
            if (_stanoxCache.ContainsKey(stanox))
            {
                return _stanoxCache[stanox];
            }
            const string sql = @"
                SELECT
                    [Tiploc].[TiplocId],
                    [Tiploc].[Tiploc],
                    [Tiploc].[Nalco],
                    [Tiploc].[Description],
                    [Tiploc].[CRS],
                    [Tiploc].[Stanox]
                FROM [Tiploc]
                WHERE [Tiploc].[Stanox] = @stanox";

            var results = Query<TiplocCode>(sql, new { stanox });
            if (results.Any())
            {
                AddToCache(stanox, results);
            }
            return results;
        }