public void ThenAllEmployeesShouldBeReturned()
 {
     using (var connection = GetDatabaseConnection.Create())
     {
         sut = new GetAllEmployees(connection);
         var listOfAllEmployees = sut.Execute();
         listOfAllEmployees.Count().Should().Be(NumberOfEmployeesToCreate);
     }
 }
 public void CleanUp()
 {
     using (var connection = GetDatabaseConnection.Create())
     {
         connection.Open();
         connection.Delete <Employee>(100);
         connection.Close();
     }
 }
 public void ThenEmployeeShouldBeDeleted()
 {
     using (var connection = GetDatabaseConnection.Create())
     {
         sut = new DeleteEmployee(connection);
         sut.Execute(newEmployeeId);
         connection.Open();
         var retrievedEmployee = connection.Get <Employee>(newEmployeeId);
         connection.Close();
         retrievedEmployee.Should().BeNull();
     }
 }
 public void Setup()
 {
     using (var connection = GetDatabaseConnection.Create())
     {
         if (connection.State != ConnectionState.Open)
         {
             connection.Open();
         }
         var fakeEmployee = new Employee {
             Name = "DELETE TEST", NumberOfDependents = 2
         };
         newEmployeeId = connection.Insert(fakeEmployee);
         connection.Close();
     }
 }
        public void Setup()
        {
            using (var connection = GetDatabaseConnection.Create())
            {
                var employeeList = Builder <Employee> .CreateListOfSize(NumberOfEmployeesToCreate).Build();

                if (connection.State != ConnectionState.Open)
                {
                    connection.Open();
                }
                connection.Delete <Employee>(100);
                foreach (var fakeEmployee in employeeList)
                {
                    connection.Insert(fakeEmployee);
                }
                connection.Close();
            }
        }