Index: Riskeer/HydraRing/src/Riskeer.HydraRing.IO/HydraulicBoundaryDatabase/HrdFileReader.cs =================================================================== diff -u -rd088ed9e249c27cf431b4bfe8bd88eab30cc18cc -r0cbe91b9dac19e488c365a6fedeba38cbf536e10 --- Riskeer/HydraRing/src/Riskeer.HydraRing.IO/HydraulicBoundaryDatabase/HrdFileReader.cs (.../HrdFileReader.cs) (revision d088ed9e249c27cf431b4bfe8bd88eab30cc18cc) +++ Riskeer/HydraRing/src/Riskeer.HydraRing.IO/HydraulicBoundaryDatabase/HrdFileReader.cs (.../HrdFileReader.cs) (revision 0cbe91b9dac19e488c365a6fedeba38cbf536e10) @@ -58,10 +58,9 @@ try { - using (IDataReader reader = CreateDataReader("SELECT L.LocationId, L.Segment, T.HRDFileName " + - "FROM Locations L " + - "INNER JOIN Tracks T USING(TrackId) " + - "WHERE L.TypeOfHydraulicDataId > 1;")) + using (IDataReader reader = CreateDataReader("SELECT HRDLocationId, Name, XCoordinate, YCoordinate " + + "FROM HRDLocations " + + "WHERE L.LocationTypeId > 1;")) { while (MoveNext(reader)) { @@ -88,7 +87,10 @@ { try { - return new ReadHrdLocation(reader.Read("LocationId")); + return new ReadHrdLocation(reader.Read("HRDLocationId"), + reader.Read("Name"), + reader.Read("XCoordinate"), + reader.Read("YCoordinate")); } catch (ConversionException e) {