linq_functions_2.cs

            stateVariations = db.StateVariations.ToArray();
// do any filtering on items other than state here, before pulling into memory
            translations = db.Translations.Filter(…).ToArray();
 
            joinedData = translations.GroupJoin(
                    stateVariations,
                    translation => translation.Id,
                    variation => variation.SystemLanguageTranslationId,
                    (translation, variation) => new { translation, variations = variation })
                    .Select(x => new CombinedDataObject
                    {
                        Id = x.translation.Id,
                        EN = x.translation.EN,
                        Variations = Mapper(x.variations),
                    });