title: Unit test code that interacts with database without creating data in database
body: <p>I want to test my C# code in Visual Studio with unit tests.
  The code interacts with a MySQL database.</p>
  
  <p><strong>An example of what I want to test</strong><br>
  A user opens my application and will be saved in the database via a webservice. Now I want to know if the table <code>Users</code> has one more row before the new user came. But if I test the method in the webservice, which will create a record in the database, test data will be in the database. And I don't want test data in my database.</p>
  
  <p>Is there a solution for this problem?</p>