Example of resetting database by executing a simple SQL script

blog-001-reset-database.cs

const string ResetSql = @"delete from a
delete from b
...
delete from m";

  // Removes any data generated by tests from the database
private void ResetDatabase()
{
	InUnitOfWork(session =>
	{
		var command = session.Connection.CreateCommand();
		command.CommandText = ResetSql;
		session.Transaction.Enlist(command);
		command.ExecuteNonQuery();
	});
}