Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs =================================================================== diff -u -rf8c28b3b04cdabb62ea37772efcb1f4ebbbf2b9e -r6d901bde3aca6427d44fa379c8948594ecc8679a --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision f8c28b3b04cdabb62ea37772efcb1f4ebbbf2b9e) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 6d901bde3aca6427d44fa379c8948594ecc8679a) @@ -27,26 +27,26 @@ public static class HydraulicLocationConfigurationDatabaseQueryBuilder { /// - /// Gets the query to get the LocationIds from the database. + /// Gets the query to get location ids from the database. /// - /// The query to get the locationIds from the database. - public static string GetLocationsIdByTrackIdQuery() + /// The query to get location ids from the database. + public static string GetLocationIdsByTrackIdQuery() { return $"SELECT {LocationsTableDefinitions.LocationId}, {LocationsTableDefinitions.HrdLocationId} " + $"FROM {LocationsTableDefinitions.TableName} " + - $"WHERE {TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId} " + + $"WHERE {LocationsTableDefinitions.TrackId} = @{LocationsTableDefinitions.TrackId} " + $"ORDER BY {LocationsTableDefinitions.HrdLocationId};"; } /// - /// Gets the query to get the UsePreprocessor indicator from the database. + /// Gets the query to get region information from the database. /// - /// The query to get the UsePreprocessor indicator from the database. - public static string GetUsePreprocessorByTrackIdQuery() + /// The query to get region information from the database. + public static string GetRegionByTrackIdQuery() { return $"SELECT * FROM {RegionsTableDefinitions.TableName} " + $"LEFT JOIN {TracksTableDefinitions.TableName} " + - $"ON {RegionsTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} = {TracksTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} " + + $"ON {RegionsTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} = {TracksTableDefinitions.TableName}.{TracksTableDefinitions.RegionId} " + $"WHERE {TracksTableDefinitions.TableName}.{TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId}"; } }