Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilder.cs =================================================================== diff -u -r85fb38b5ff4ef61c053ffef928570cd75cfa9357 -r00cd167e5b3fe6e817e063ab654459c90e550aea --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 85fb38b5ff4ef61c053ffef928570cd75cfa9357) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabase/HydraulicLocationConfigurationDatabaseQueryBuilder.cs (.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs) (revision 00cd167e5b3fe6e817e063ab654459c90e550aea) @@ -37,17 +37,5 @@ $"WHERE {LocationsTableDefinitions.TrackId} = @{LocationsTableDefinitions.TrackId} " + $"ORDER BY {LocationsTableDefinitions.HrdLocationId};"; } - - /// - /// Gets the query to get region information from the database. - /// - /// 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}.{TracksTableDefinitions.RegionId} " + - $"WHERE {TracksTableDefinitions.TableName}.{TracksTableDefinitions.TrackId} = @{TracksTableDefinitions.TrackId}"; - } } } \ No newline at end of file