title: Unit tests: creating and deleting entry with SQL Query
body: <p>I'm pretty new to this, and I'm trying to make a test where I can create and delete an object in a mock Database but I have no idea where to start now or how to create that Mock database and read/write to it.</p>
  
  <pre><code>    [Fact]
      public void CreateCommentaar()
      {
          //arrange
          Commentaar commentaar = new Commentaar
          {
              CommentaarId = 0,
              StadId = 0,
              UserId = "testId",
              CommentaarText = "text",
              Tijdstip = DateTime.Now
          };
  
          string queryString = "INSERT INTO Commentaar(UserId, StadId, CommentaarText, Tijdstip) VALUES("
              + commentaar.CommentaarId + " ,"
              + commentaar.UserId + " ,"
              + commentaar.StadId + " ,"
              + commentaar.CommentaarText + " ,"
              + commentaar.Tijdstip + " ,";
  
          //act
          //Run Mock sql query
  
          //assert
          //1 commentaar object should exist in mock DB now
  
      }
  
      [Fact]
      public void DeleteCommentaar()
      {
          //arrange
          Commentaar commentaar = new Commentaar
          {
              CommentaarId = 0,
              StadId = 0,
              UserId = "testId",
              CommentaarText = "text",
              Tijdstip = DateTime.Now
          };
  
          string queryString = "INSERT INTO Commentaar(UserId, StadId, CommentaarText, Tijdstip) VALUES("
              + commentaar.CommentaarId + " ,"
              + commentaar.UserId + " ,"
              + commentaar.StadId + " ,"
              + commentaar.CommentaarText + " ,"
              + commentaar.Tijdstip + " ,";
  
          //act
          //Run Mock sql query
  
          //assert
          //1 commentaar object should be deleted
      }
  </code></pre>
  
  <p>I'm not really sure how to continue from here though.</p>