How to execute SQL Query from Visual studio 2017 using Test Automation

how to execute SQL Query from Visual studio 2017. I am writing Automated tests. Once the Test Execution is completed. I want to execute the set of SQL commands automatically to reset the test data. Manually I have made the connection to DB and Run the query from Visual studio, but I want to include a test method at the end of test execution to run the SQL Query. I'm sort of new to C#. let me know what all namespace and methods needs to be incorporated.