Simple Query

gistfile1.cs

                var attendees = repository.GetAttendess();

                var registrations = repository.GetRegistrationsForMeeting(meetingId, searchTerm);

                var query = from registration in registrations
                            join attendee in attendees on registration.WebUser equals attendee.WebUser
                            orderby registration.Updated
                            select new MeetingListProjection
                                       {
                                           UserID = registration.WebUser.ID,
                                           RegistrationOn = registration.RegistrationOn,
                                           Date = registration.Meeting.Date.ToShortDateString(),
                                           MeetingID = registration.Meeting.ID,
                                           PlaceName = registration.Meeting.Place.Name,
                                           Name = registration.Meeting.Name,
                                           Price = registration.Fee,
                                           WebUserEMail = registration.WebUser.EMail,
                                           Attendant = registration.Attendant,
                                           AttendeeName = attendee.LastName + " " + attendee.FirstName,
                                           CompanyName = attendee.CompanyName,
                                           RegistrationID = registration.ID,
                                           PayedOn = registration.PayedOn,
                                       };