public StationTiploc GetByStationName(string stationName)
{
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 [Station].[StationName] = @stationName";
return Query<StationTiploc>(sql, new { stationName }).FirstOrDefault();
}