public async Task GetLakeRatersCountByValueShouldWorkCorrect()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()).Options;
using var db = new ApplicationDbContext(options);
var lakeRepository = new EfDeletableEntityRepository <Lake>(db);
var lakeVoteRepository = new EfRepository <LakeVote>(db);
var trophyVoteRepository = new EfRepository <TrophyVote>(db);
var votesRepository = new EfRepository <Vote>(db);
var service = new VotesService(lakeVoteRepository, trophyVoteRepository, votesRepository);
await lakeRepository.AddAsync(new Lake { Id = 1 });
await lakeRepository.AddAsync(new Lake { Id = 2 });
await service.SetLakeVoteAsync(1, "someuserid123", 5);
await service.SetLakeVoteAsync(1, "someuserid1234", 5);
await service.SetLakeVoteAsync(2, "someuserid12345", 2);
Assert.Equal(2, service.GetLakeRatersCountByValue(1, 5));
Assert.Equal(0, service.GetLakeRatersCountByValue(1, 4));
Assert.Equal(1, service.GetLakeRatersCountByValue(2, 2));
}