"developer/test" mode for SQL Databases

I am new to a relatively large project using a Microsoft SQL server database with C# and the Entity Framework.

The current development process is like this:

• Code some feature/intend to fix a bug
• Start the application
• Make some changes via GUI to the database testing the coded functionality/testing if the bug was fixed
• In case of failure -> run SQL scripts to delete the complete database changes and repeat the whole procedure

I am wondering if there is any "test/developer"-mode for SQL databases that could automatically revert the applied changes. Basically, while the program is running, everything should be inserted/updated/deleted to the actual database, but afterwards all changes should automatically be reverted. Is my thought completely unreasonable? Is our procedure with the SQL scripts more or less state of the art for database development?

Thanks in advance!