|
public GetAllByStanox ( string stanox ) : IEnumerable |
||
| stanox | string | |
| return | IEnumerable |
|
public IEnumerable<StationTiploc> GetAllByStanox(string stanox)
{
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].[Stanox] = @stanox";
return Query<StationTiploc>(sql, new { stanox });
}