Provider = (from ap in ef_Office.ProvidersAttending
                                       where m.AttendingProviderID == ap.ProviderID
                                       select new
                                       {
                                           ProviderID = ap.ProviderID,
                                           FirstName = ap.FirstName,
                                           LastName = ap.LastName,
                                           SpecialtyID = ap.SpecialtyID,
                                           Specialty = (from sp in ef_Office.Specialties
                                                        where sp.SpecialtyID == ap.SpecialtyID
                                                        select sp.Specialty).FirstOrDefault()
                                       }).Take(1).FirstOrDefault(),