public TiplocCode GetTiplocByStanox(string stanox)
{
if (_stanoxCache.ContainsKey(stanox))
{
return _stanoxCache[stanox].FirstOrDefault();
}
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.FirstOrDefault();
}