public List <ContactData> GetContacts() { DataConnection.DefaultSettings = new MySettings(); using AddressBookDb db = new AddressBookDb(); return((from c in db.Contacts from gcr in db.GCR.Where(p => p.GroupId == Id && p.ContactId == c.Id && c.Deprecated == "0000-00-00 00:00:00") select c).Distinct().ToList()); }
public static List <GroupData> GetAll() { DataConnection.DefaultSettings = new MySettings(); using AddressBookDb db = new AddressBookDb(); return((from g in db.Groups select g).ToList()); }