u/zaibufin r/dotnet • Recommends
On “Unit Testing”
You can watch these two by Nick:
The cleanest way to use Docker for testing in .NET
The BEST way to reset your database for testing in .NET
If you want a full course I can recommend his course From Zero to Hero: Integration testing in ASP.NET Core, it's paid but money well spent.
I recommend using TestContainers for dotnet. Very easy to spin up any database for your test suite and then dispose it after the test run is done.