public IEnumerable<StationTiploc> GetAllByCRSCode(string crsCode)
{
const string sql = @"
SELECT
[Tiploc].[TiplocId],
[Tiploc].[Tiploc],
[Tiploc].[Nalco],
[Tiploc].[Description],
[Tiploc].[CRS],
[Tiploc].[Stanox],
[Station].[StationName],
[Station].[Location].[Lat] AS [Lat],
[Station].[Location].[Long] AS [Lon]
FROM [Tiploc]
LEFT JOIN [Station] ON [Tiploc].[TiplocId] = [Station].[TiplocId]
WHERE [Tiploc].[CRS] = @crsCode OR [Station].[SubsiduaryAlphaCode] = @crsCode";
return Query<StationTiploc>(sql, new { crsCode });
}