public void ShouldAddGetDeleteReference() { //arrange var reference = new Reference { CommentId = Guid.Parse("6a4121a7-2b12-41e6-a408-8b13ef7d0b53") /*Guid.NewGuid()*/, UserId = Guid.Parse("3c8fddae-8ebc-4cd4-9eb2-30ce678d6c23")/*Guid.NewGuid()*/ }; //act var dataLayer = new DataLayer.Sql.DataLayer(_connectionString); var addReference = dataLayer.AddReference(reference); var dataLayer1 = new DataLayer.Sql.DataLayer(_connectionString); var getReference = dataLayer1.GetReference(addReference.ReferenceId); var dataLayer2 = new DataLayer.Sql.DataLayer(_connectionString); int isDeleted = dataLayer2.DeleteReference(getReference.ReferenceId); //asserts Assert.AreEqual(addReference.ReferenceId, getReference.ReferenceId); Assert.AreEqual(addReference.CommentId, getReference.CommentId); Assert.AreEqual(addReference.UserId, getReference.UserId); Assert.IsNotNull(isDeleted); }