Skip to content

Instantly share code, notes, and snippets.

@gasparnagy
Last active August 29, 2015 14:16
Show Gist options
  • Save gasparnagy/8e9b6a80d79cd8bd26f7 to your computer and use it in GitHub Desktop.
Save gasparnagy/8e9b6a80d79cd8bd26f7 to your computer and use it in GitHub Desktop.
[BeforeScenario]
public void BeforeScenario()
{
var tablesToClean = new[] {"OrderItems", "Orders", "Audit"};
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB"].ConnectionString))
{
foreach (var table in tablesToClean)
{
connection.Open();
using (var cmd = new SqlCommand("TRUNCATE TABLE " + table, connection))
{
cmd.ExecuteNonQuery();
}
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment