public static List <GroupData> GetAllFromDB() { using (AddressBookDB db = new AddressBookDB()) { return((from g in db.Groups select g).ToList()); } }
public static List <ContactData> GetAllFromDB() { using (AddressBookDB db = new AddressBookDB()) { return((from c in db.Contacts.Where(x => x.Deprecated == "0000-00-00 00:00:00") select c).ToList()); } }
public List <ContactData> GetContacts() { using (AddressBookDB db = new AddressBookDB()) { return((from c in db.Contacts from groupcontactlink in db.GroupContactLink.Where( p => p.GroupId == Id && p.ContactId == c.Id && c.Deprecated == "0000-00-00 00:00:00") select c).Distinct().ToList()); } }
public List <GroupData> GetGroups() { using (AddressBookDB db = new AddressBookDB()) { var query = from g in db.Groups join t in db.GroupContactLink on g.Id equals t.GroupId where t.ContactId == Id select g; /* * from groupcontactlink in db.GroupContactLink.Where( * p => p.ContactId == Id * && p.GroupId == g.Id) * select g; */ return(query.Distinct().ToList()); } }