finished dal and integration tests samples