Home
Shortcoming: Data integrity verification
Description: Verifies the database contains exactly 3 blog posts after seeding
Example: "After seeding, the database should contain exactly 3 blog posts"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L71-L79
[TestMethod]
public void SeedData_ContainsExactlyThreeBlogPosts()
{
var postCount = _context.BlogPosts.Count();
Assert.AreEqual(3, postCount);
}Shortcoming: Data consistency verification
Description: Checks Post1 has exactly 3 comments as specified
Example: "Post titled 'Post1' should contain exactly 3 comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L81-L92
[TestMethod]
public void SeedData_Post1_HasExactlyThreeComments()
{
var commentCount = _context.BlogPosts
.Include(p => p.Comments)
.First(p => p.Title == "Post1")
.Comments.Count;
Assert.AreEqual(3, commentCount);
}Shortcoming: Data consistency verification
Description: Verifies Post2 has exactly 2 comments
Example: "Post titled 'Post2' should contain exactly 2 comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L94-L105
[TestMethod]
public void SeedData_Post2_HasExactlyTwoComments()
{
var commentCount = _context.BlogPosts
.Include(p => p.Comments)
.First(p => p.Title == "Post2")
.Comments.Count;
Assert.AreEqual(2, commentCount);
}Shortcoming: Data consistency verification
Description: Ensures Post3 has exactly 4 comments
Example: "Post titled 'Post3' should contain exactly 4 comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L107-L118
[TestMethod]
public void SeedData_Post3_HasExactlyFourComments()
{
var commentCount = _context.BlogPosts
.Include(p => p.Comments)
.First(p => p.Title == "Post3")
.Comments.Count;
Assert.AreEqual(4, commentCount);
}Shortcoming: Date validation
Description: Confirms no comments have future dates
Example: "All comments should have creation dates in the past"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L120-L130
[TestMethod]
public void SeedData_AllCommentsHaveValidDates()
{
var invalidDates = _context.BlogComments
.Where(c => c.CreatedDate > DateTime.Now)
.ToList();
Assert.AreEqual(0, invalidDates.Count);
}Shortcoming: Complex query verification
Description: Validates comment count for user Petr
Example: "User 'Petr' should have exactly 2 comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L137-L147
[TestMethod]
public void Query1_CountCommentsPerUser_PetrHasTwoComments()
{
var petrComments = _context.BlogPosts
.SelectMany(p => p.Comments)
.Count(c => c.UserName == "Petr");
Assert.AreEqual(2, petrComments);
}Shortcoming: Complex query verification
Description: Validates comment count for user Elena
Example: "User 'Elena' should have exactly 3 comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L149-L159
[TestMethod]
public void Query1_CountCommentsPerUser_ElenaHasThreeComments()
{
var elenaComments = _context.BlogPosts
.SelectMany(p => p.Comments)
.Count(c => c.UserName == "Elena");
Assert.AreEqual(3, elenaComments);
}Shortcoming: Complex query verification
Description: Validates comment count for user Ivan
Example: "User 'Ivan' should have exactly 4 comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L161-L171
[TestMethod]
public void Query1_CountCommentsPerUser_IvanHasFourComments()
{
var ivanComments = _context.BlogPosts
.SelectMany(p => p.Comments)
.Count(c => c.UserName == "Ivan");
Assert.AreEqual(4, ivanComments);
}Shortcoming: Sorting verification
Description: Checks post ordering by most recent comment
Example: "Posts should be ordered as Post2, Post1, Post3 by last comment date"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L173-L191
[TestMethod]
public void Query2_PostsOrderedByLastCommentDate_CorrectOrder()
{
var orderedPosts = _context.BlogPosts
.Select(p => new {
p.Title,
LastCommentDate = p.Comments.Max(c => c.CreatedDate)
})
.OrderByDescending(p => p.LastCommentDate)
.Select(p => p.Title)
.ToList();
CollectionAssert.AreEqual(
new List<string> { "Post2", "Post1", "Post3" },
orderedPosts
);
}Shortcoming: Complex query verification
Description: Validates count of most recent comments by Ivan
Example: "User 'Ivan' should have 2 most recent comments across posts"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L173-L191
[TestMethod]
public void Query3_CountLastCommentsPerUser_IvanHasTwo()
{
var ivanLastComments = _context.BlogPosts
.Select(p => p.Comments
.OrderByDescending(c => c.CreatedDate)
.First())
.Count(c => c.UserName == "Ivan");
Assert.AreEqual(2, ivanLastComments);
}Shortcoming: Performance verification
Description: Ensures post retrieval meets performance requirements
Example: "Getting all posts should complete in under 50ms"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L225-L238
[TestMethod]
public void Query_Performance_GetAllPostsUnder50ms()
{
var stopwatch = new Stopwatch();
stopwatch.Start();
var posts = _context.BlogPosts.ToList();
stopwatch.Stop();
Assert.IsTrue(stopwatch.ElapsedMilliseconds < 50);
}Shortcoming: Create operation verification
Description: Tests blog post creation persistence
Example: "New post 'New Post' should be saved to database"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L245-L257
[TestMethod]
public void Create_NewBlogPost_SavesToDatabase()
{
var newPost = new BlogPost("New Post");
_context.BlogPosts.Add(newPost);
_context.SaveChanges();
Assert.IsTrue(_context.BlogPosts.Any(p => p.Title == "New Post"));
}Shortcoming: Create operation verification
Description: Tests comment creation persistence
Example: "New comment 'New Comment' should be saved to database"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L259-L272
[TestMethod]
public void Create_NewComment_SavesToDatabase()
{
var post = _context.BlogPosts.First();
var newComment = new BlogComment("New Comment", DateTime.Now, "TestUser");
post.Comments.Add(newComment);
_context.SaveChanges();
Assert.IsTrue(_context.BlogComments.Any(c => c.Text == "New Comment"));
}Shortcoming: Update operation verification
Description: Tests post title update persistence
Example: "Post title should update to 'Updated Title' in database"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L274-L287
[TestMethod]
public void Update_BlogPostTitle_UpdatesInDatabase()
{
var post = _context.BlogPosts.First();
var newTitle = "Updated Title";
post.Title = newTitle;
_context.SaveChanges();
Assert.AreEqual(newTitle, _context.BlogPosts.Find(post.Id).Title);
}Shortcoming: Delete operation verification
Description: Tests post deletion from database
Example: "Deleted post should no longer exist in database"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L289-L301
[TestMethod]
public void Delete_BlogPost_RemovesFromDatabase()
{
var post = _context.BlogPosts.First();
_context.BlogPosts.Remove(post);
_context.SaveChanges();
Assert.IsFalse(_context.BlogPosts.Any(p => p.Id == post.Id));
}Shortcoming: Navigation property verification
Description: Tests comment to post navigation
Example: "Comment should correctly reference its parent post"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L325-L336
[TestMethod]
public void BlogComment_BlogPostNavigation_IsCorrect()
{
var comment = _context.BlogComments
.Include(c => c.BlogPost)
.First();
Assert.IsNotNull(comment.BlogPost);
Assert.AreEqual(comment.BlogPostId, comment.BlogPost.Id);
}Shortcoming: Navigation property verification
Description: Tests post to comments navigation
Example: "Post should correctly reference all its comments"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L338-L349
[TestMethod]
public void BlogPost_CommentsNavigation_IsCorrect()
{
var post = _context.BlogPosts
.Include(p => p.Comments)
.First();
Assert.IsNotNull(post.Comments);
Assert.IsTrue(post.Comments.All(c => c.BlogPostId == post.Id));
}Shortcoming: Empty collection handling
Description: Tests behavior of posts with no comments
Example: "New post with no comments should return empty collection"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L351-L367
[TestMethod]
public void BlogPost_WithNoComments_ReturnsEmptyCollection()
{
var newPost = new BlogPost("Empty Post");
_context.BlogPosts.Add(newPost);
_context.SaveChanges();
var comments = _context.Entry(newPost)
.Collection(p => p.Comments)
.Query()
.ToList();
Assert.AreEqual(0, comments.Count);
}Shortcoming: Serialization verification
Description: Tests JSON serialization of post titles
Example: "Serialized JSON should contain all post titles"
Test Method: https://github.com/shadyashraf174/Blog/blob/master/UnitTest.cs#L374-L386
[TestMethod]
public void JsonOutput_ContainsAllPostTitles()
{
var json = System.Text.Json.JsonSerializer.Serialize(
_context.BlogPosts.Select(p => p.Title).ToList()
);
Assert.IsTrue(json.Contains("Post1"));
Assert.IsTrue(json.Contains("Post2"));
Assert.IsTrue(json.Contains("Post3"));
}