Index: Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs
===================================================================
diff -u -r25dd6ff5b74aec73e47df4488c05439a143711e1 -r86e6bb44ba1ccbec534f3fcf379481ea8d45d67f
--- Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 25dd6ff5b74aec73e47df4488c05439a143711e1)
+++ Ringtoets/Piping/test/Ringtoets.Piping.IO.Test/Builders/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 86e6bb44ba1ccbec534f3fcf379481ea8d45d67f)
@@ -61,6 +61,23 @@
         }
 
         [Test]
+        public void GetStochasticSoilModelOfMechanismCountQuery_Always_ReturnsExpectedValues()
+        {
+            // Setup
+            const string expectedQuery = "SELECT COUNT('1') AS nrOfRows " +
+                                         "FROM Mechanism M " +
+                                         "INNER JOIN Segment S USING(ME_ID) " +
+                                         "INNER JOIN StochasticSoilModel SSM USING(SSM_ID) " +
+                                         "WHERE M.ME_Name = @ME_Name;";
+
+            // Call
+            string query = SoilDatabaseQueryBuilder.GetStochasticSoilModelOfMechanismCountQuery();
+
+            // Assert
+            Assert.AreEqual(expectedQuery, query);
+        }
+
+        [Test]
         public void GetCheckVersionQuery_Always_ReturnsExpectedValues()
         {
             // Setup