Index: Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs
===================================================================
diff -u -r194139b3a9e8d221e69a4e5ff4adaa458eaedef5 -r733d0d51adf737c52704cd80705507fdb34a2ba3
--- Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs	(.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs)	(revision 194139b3a9e8d221e69a4e5ff4adaa458eaedef5)
+++ Ringtoets/HydraRing/src/Ringtoets.HydraRing.IO/HydraulicLocationConfigurationDatabaseContext/HydraulicLocationConfigurationDatabaseQueryBuilder.cs	(.../HydraulicLocationConfigurationDatabaseQueryBuilder.cs)	(revision 733d0d51adf737c52704cd80705507fdb34a2ba3)
@@ -29,18 +29,25 @@
     public static class HydraulicLocationConfigurationDatabaseQueryBuilder
     {
         /// <summary>
-        /// Returns the query to get the LocationId from the database, based upon <paramref name="regionId"/> and <paramref name="hrdLocationId"/>.
+        /// Returns the query to get the LocationId from the database.
         /// </summary>
         /// <returns>The query to get the locationId from the database.</returns>
-        public static string GetLocationIdQuery(int regionId, int hrdLocationId)
+        public static string GetLocationIdQuery()
         {
-            return String.Format("SELECT {0} FROM {1} WHERE {2} = {3} AND {4} = {5};",
+            var countQuery = String.Format("Select COUNT({0}) FROM {1} WHERE {2} = @{2} AND {3} = @{3}",
+                                           LocationsTableDefinitions.LocationId,
+                                           LocationsTableDefinitions.TableName,
+                                           LocationsTableDefinitions.RegionId,
+                                           LocationsTableDefinitions.HrdLocationId);
+
+            return String.Format("SELECT {0}, ({1}) as {2} FROM {3} WHERE {4} = @{4} AND {5} = @{5};",
                                  LocationsTableDefinitions.LocationId,
+                                 countQuery,
+                                 LocationsTableDefinitions.Count,
                                  LocationsTableDefinitions.TableName,
                                  LocationsTableDefinitions.RegionId,
-                                 hrdLocationId,
-                                 LocationsTableDefinitions.HrdLocationId,
-                                 regionId);
+                                 LocationsTableDefinitions.HrdLocationId
+                );
         }
     }
 }
\ No newline at end of file