title: C#, NUnit Assert in a Loop
body: <p>I have a school assignment where I need to create a data-driven style of NUnit testing. Using the below code, I am able to get the data from the database, but everytime an 'Assert' call fails, the test is stopped.</p>
  
  <p>Is there any way in which I can actually show the results of the loop as six different tests (considering I have six rows in my database)?</p>
  
  <pre><code>namespace TestClasses
  {
      [TestFixture]
      public class TestingClass : ConnectionClass
      {
          private ProductManagement pm;
  
          [TestFixtureSetUp]
          public void CreateTestClass()
          {
              pm = new ProductManagement();
          }
  
          [TestCase]
          public void GetProductDetailsTest()
          {
              SqlDataAdapter da = new SqlDataAdapter("Select * From GetProductDetailsTest;", Connection);
              Database1DataSet.GetProductDetailsTestDataTable dt = new Database1DataSet.GetProductDetailsTestDataTable();
              da.Fill(dt);
  
              foreach (Database1DataSet.GetProductDetailsTestRow dr in dt.Rows)
              {
                  if (pm.GetProductById(dr.productId) == null)
                      Assert.Fail("Id of test case: " + dr.id + ", Product id of failure: " + dr.productId);
              }
          }
      }
  }
  </code></pre>
  
  <p>Basically what I am looking for is, for NUnit to display 3 passed tests and 3 failed tests, if possible! Any help would be greatly appreciated, thanks! :)</p>