public List <GroupData> GetGroups() { using (AddressbookDB db = new AddressbookDB()) { return((from g in db.Groups from gcr in db.GCR.Where(P => P.GroupId == g.Id && P.ContactId == Id && g.Deprecated == "0000-00-00 00:00:00") select g).Distinct().ToList()); } }
public static List <ContactData> GetAll() { using (AddressbookDB db = new AddressbookDB())//устанавливает соединение) { return((from c in db.Contacts select c).ToList()); } }
public static List <GroupData> GetAll() { using (AddressbookDB db = new AddressbookDB()) { return((from g in db.Groups select g).ToList()); } }
public List <ContactData> GetContacts() { 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()); } }