gistfile1.cs

 public class InviteList_Hydrated : AbstractIndexCreationTask<InviteList>
    {
        public InviteList_Hydrated()
        {
            Map = docs => from doc in docs select new { doc.Name, doc.Site.Id };

            TransformResults = (db, docs) => from doc in docs
                                             let Households = (
                                                 from hh in doc.Households
                                                 let household = db.Load<Archant.Wedding.Areas.AddressBook.Models.Household>(hh.Id)
                                                 let PrimaryContact = db.Load<PrimaryContact>(household.PrimaryContact.Id)
                                                 let Partner = db.Load<Partner>(household.Partner.Id)
                                                 let Children = db.Load<Child>((from c in household.Children select c.Id).ToList())
                                                 select new
                                                 {
                                                     household.Id,
                                                     household.Name,
                                                     PrimaryContact,
                                                     Partner,
                                                     Children
                                                 })
                                             let Site = db.Load<Site>(doc.Site.Id)
                                             select new
                                             {
                                                 doc.Deleted,
                                                 Households,
                                                 doc.Id,
                                                 doc.Name,
                                                 Site
                                             };


        }
    }