Unit test code that interacts with the database without creating data in the database

Question

I want to test my C # code in Visual Studio with unit tests. The code interacts with the MySQL database.

An example of what I want to check. A
user opens my application and will be saved to the database through webservice. Now I want to know if the table Usershas another row before a new user appears. But if I test the method in a web service that will create an entry in the database, the test data will be in the database. And I do not need test data in my database.

Is there a solution to this problem?

Answer 1

, , . -.

, moq moh.

, , . , .

Answer 2

, , - Mock. , Moq #.

unit test. , , .

Answer 3

- .

( , ), MySql.

, MySql .

Nuget (Mysql.Server) : https://github.com/stumpdk/MySql.Server

Answer 4

Microsoft . https://docs.microsoft.com/en-us/visualstudio/test/isolating-code-under-test-with-microsoft-fakes?view=vs-2017