© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
C#C
C#•13mo ago•
133 replies
surwren

✅ Mocking DB operations

Say I have a function and I need to verify that the saved UserFollow object will:

1. Cause the user objects to be retrieved if UserFollow retrieves them eagerly
2. Cause the userFollow to be retrieved if a User is retrieved with said fields eagerly

public async Task<bool> AddFollowerByPrivateIdAsync(int userPrivateId, int followerPrivateId) { 
public async Task<bool> AddFollowerByPrivateIdAsync(int userPrivateId, int followerPrivateId) { 

var user = await _context.Users.FirstOrDefaultAsync(u => u.PrivateId == userPrivateId);
var user = await _context.Users.FirstOrDefaultAsync(u => u.PrivateId == userPrivateId);

var follower = await _context.Users.FirstOrDefaultAsync(u => u.PrivateId == followerPrivateId);
var follower = await _context.Users.FirstOrDefaultAsync(u => u.PrivateId == followerPrivateId);

if (user == null || follower == null) {
if (user == null || follower == null) {

return false;
return false;

}
}

var userFollow = new UserFollow {
var userFollow = new UserFollow {

FollowedId =
FollowedId =
[
user.Id
user.Id
]
FollowerId =
FollowerId =
[
follower.Id
follower.Id
]
Type = FollowType.Requested,
Type = FollowType.Requested,

Followed = user,
Followed = user,

Follower = follower
Follower = follower

};
};

_context.UserFollows.Add(userFollow);
_context.UserFollows.Add(userFollow);

await _context.SaveChangesAsync();
await _context.SaveChangesAsync();

return true;
return true;

}
}


How would I test this? I have looked at XUnit and MockItEasy but it doesn't look like they are dealing with the Database, but rather dependencies for abstracted code.
C# banner
C#Join
We are a programming server aimed at coders discussing everything related to C# (CSharp) and .NET.
61,871Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements
Next page

Similar Threads

TDD: Mocking services
C#CC# / help
2y ago
❔ Mocking with EntityFrameworkCore
C#CC# / help
4y ago
✅ Problems with mocking a ServiceProvider
C#CC# / help
3y ago
❔ Mocking EF Core extensions methods.
C#CC# / help
3y ago