C#
    public async Task<ICollection<BenefitEntity>> GetAllBenefitEntitiesAsync()
    {
        var benefitsQuery = Entities
            .Include(a => a.CategoryEntity);

        var translationsQuery = DbContext.TranslationsEntities!
            .AsNoTracking()
            .Where(e => e.Language.Equals(LANGUAGE));

        var benefits = await benefitsQuery.ToListAsync();

        var result = benefits
            .GroupJoin(
                translationsQuery,
                benefit => benefit.Id,
                translation => translation.EntityId,
                (benefit, translation) => new { Benefit = benefit, Translation = translation })
            .Select(result => new BenefitEntity
            {
                    // Benefit Name and Description from joined translations
                    Name = result.Translation.FirstOrDefault(e => e.Property.Equals(nameof(BenefitEntity.Name)))?.Value ?? result.Benefit.Name,
                    Description = result.Translation.FirstOrDefault(e => e.Property.Equals(nameof(BenefitEntity.Description)))?.Value ?? result.Benefit.Description,
                    Id = result.Benefit.Id,
                    CategoryEntity = result.Benefit.CategoryEntity,
                    BenefitCategoryId = result.Benefit.BenefitCategoryId,
            })
            .AsQueryable();

        return result.ToList();
}

C#
    public async Task<ICollection<BenefitEntity>> GetAllBenefitEntitiesAsync()
    {
        var benefitsQuery = Entities
            .Include(a => a.CategoryEntity);

        var translationsQuery = DbContext.TranslationsEntities!
            .AsNoTracking()
            .Where(e => e.Language.Equals(LANGUAGE));

        var benefits = await benefitsQuery.ToListAsync();

        var result = benefits
            .GroupJoin(
                translationsQuery,
                benefit => benefit.Id,
                translation => translation.EntityId,
                (benefit, translation) => new { Benefit = benefit, Translation = translation })
            .Select(result => new BenefitEntity
            {
                    // Benefit Name and Description from joined translations
                    Name = result.Translation.FirstOrDefault(e => e.Property.Equals(nameof(BenefitEntity.Name)))?.Value ?? result.Benefit.Name,
                    Description = result.Translation.FirstOrDefault(e => e.Property.Equals(nameof(BenefitEntity.Description)))?.Value ?? result.Benefit.Description,
                    Id = result.Benefit.Id,
                    CategoryEntity = result.Benefit.CategoryEntity,
                    BenefitCategoryId = result.Benefit.BenefitCategoryId,
            })
            .AsQueryable();

        return result.ToList();
}