Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseQueryBuilder.cs =================================================================== diff -u -r91528185073758d51bf167a1705e15124ec4d50b -raf7da5c975c117189984dfd1c22783a092029235 --- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseQueryBuilder.cs (.../HydraulicBoundaryDatabaseQueryBuilder.cs) (revision 91528185073758d51bf167a1705e15124ec4d50b) +++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseQueryBuilder.cs (.../HydraulicBoundaryDatabaseQueryBuilder.cs) (revision af7da5c975c117189984dfd1c22783a092029235) @@ -48,17 +48,6 @@ } /// - /// Returns the query to get the amount of relevant locations from the database. - /// - /// The query to get the amount of relevant locations from the database. - public static string GetRelevantLocationsCountQuery() - { - return $"SELECT count({HrdLocationsTableDefinitions.HrdLocationId}) as {HrdLocationsTableDefinitions.Count} " + - $"FROM {HrdLocationsTableDefinitions.TableName} " + - $"WHERE {HrdLocationsTableDefinitions.LocationTypeId} > 1;"; // Value > 1 makes it relevant - } - - /// /// Returns the query to get all relevant locations from the database. /// /// The query to get all relevant locations from the database. Index: Ringtoets/HydraRing/test/Ringtoets.HydraRing.IO.Test/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseQueryBuilderTest.cs =================================================================== diff -u -r91528185073758d51bf167a1705e15124ec4d50b -raf7da5c975c117189984dfd1c22783a092029235 --- Ringtoets/HydraRing/test/Ringtoets.HydraRing.IO.Test/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseQueryBuilderTest.cs (.../HydraulicBoundaryDatabaseQueryBuilderTest.cs) (revision 91528185073758d51bf167a1705e15124ec4d50b) +++ Ringtoets/HydraRing/test/Ringtoets.HydraRing.IO.Test/HydraulicBoundaryDatabase/HydraulicBoundaryDatabaseQueryBuilderTest.cs (.../HydraulicBoundaryDatabaseQueryBuilderTest.cs) (revision af7da5c975c117189984dfd1c22783a092029235) @@ -50,17 +50,6 @@ } [Test] - public void GetRelevantLocationsCountQuery_Always_ReturnsExpectedValues() - { - // Call - string query = HydraulicBoundaryDatabaseQueryBuilder.GetRelevantLocationsCountQuery(); - - // Assert - const string expectedQuery = "SELECT count(HRDLocationId) as nrOfRows FROM HRDLocations WHERE LocationTypeId > 1;"; - Assert.AreEqual(expectedQuery, query); - } - - [Test] public void GetRelevantLocationsQuery_Always_ReturnsExpectedValues() { // Call