Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs =================================================================== diff -u -r64d60335b1deab4bafd37f78f3514660cc4afb27 -rf8c28b3b04cdabb62ea37772efcb1f4ebbbf2b9e --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 64d60335b1deab4bafd37f78f3514660cc4afb27) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision f8c28b3b04cdabb62ea37772efcb1f4ebbbf2b9e) @@ -27,16 +27,27 @@ public static class HydraulicLocationConfigurationDatabaseQueryBuilder { /// - /// Returns the query to get the LocationIds from the database. + /// Gets the query to get the LocationIds from the database. /// /// The query to get the locationIds from the database. public static string GetLocationsIdByTrackIdQuery() { - return string.Format("SELECT {0}, {1} FROM {2} WHERE {3} = @{3} ORDER BY {1};", - LocationsTableDefinitions.LocationId, - LocationsTableDefinitions.HrdLocationId, - LocationsTableDefinitions.TableName, - LocationsTableDefinitions.TrackId); + return $"SELECT {LocationsTableDefinitions.LocationId}, {LocationsTableDefinitions.HrdLocationId} " + + $"FROM {LocationsTableDefinitions.TableName} " + + $"WHERE {TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId} " + + $"ORDER BY {LocationsTableDefinitions.HrdLocationId};"; } + + /// + /// Gets the query to get the UsePreprocessor indicator from the database. + /// + /// The query to get the UsePreprocessor indicator from the database. + public static string GetUsePreprocessorByTrackIdQuery() + { + return $"SELECT * FROM {RegionsTableDefinitions.TableName} " + + $"LEFT JOIN {TracksTableDefinitions.TableName} " + + $"ON {RegionsTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} = {TracksTableDefinitions.TableName}.{RegionsTableDefinitions.RegionId} " + + $"WHERE {TracksTableDefinitions.TableName}.{TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId}"; + } } } \ No newline at end of file