public static List <GroupData> GetAll() { using (AddressBookDB db = new AddressBookDB()) { return((from g in db.Groups select g).ToList()); } }
public static List <ContactData> GetAll() { using (AddressBookDB db = new AddressBookDB()) { return((from co in db.Contacts.Where(x => x.Deprecated == "0000-00-00 00:00:00") select co).ToList()); } }
public static List <ContactData> GetAll() { using (AddressBookDB db = new AddressBookDB()) { return((from c in db.Contacts select c).ToList().FindAll (cont => cont.Deprecated == "01.01.0001 0:00:00")); } }
public static List <GroupData> GetAll() { using (//в этой конструкции юзинга db.close вызывается автоматически, т.о. мы уменьшаем количество кода AddressBookDB db = new AddressBookDB()) { return((from g in db.Groups select g).Distinct().ToList()); } }
public static List <GroupData> GetAllFromDb() { AddressBookDB db = new AddressBookDB(); List <GroupData> listFromDB = (from g in db.Groups select g).ToList(); db.Close(); return(listFromDB); }
public static List <ContactData> GetAllFromDb() { AddressBookDB db = new AddressBookDB(); List <ContactData> listFromDB = (from c in db.Contacts.Where(x => x.Depricated == "0000-00-00 00:00:00") select c).ToList(); db.Close(); return(listFromDB); }
public static List <GroupData> GetAll() { //установить соединение using (AddressBookDB db = new AddressBookDB()) { return((from g in db.Groups select g).ToList()); } }
public List <GroupData> GetGroups() { using (AddressBookDB db = new AddressBookDB()) { return((from g in db.Groups from gcr in db.GCRelation.Where(p => p.ContactId == Id && p.GroupId == g.Id && g.Deprecated == "0000-00-00 00:00:00") select g).Distinct().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()); } }
public static List <GroupData> GetContactGroupName(ContactData contact) { using (AddressBookDB db = new AddressBookDB()) { return((from gcr in db.GCR from gr in db.Groups where (contact.Id == gcr.ContactId && gcr.GroupId == gr.Id) select gr).Distinct().ToList()); } }
public static List <GroupData> GetAll() { using (AddressBookDB db = new AddressBookDB()) { return((from g in db.Groups select g).ToList()); } // AddressBookDB db = new AddressBookDB(); // List<GroupData> fromDb = (from g in db.Groups select g).ToList(); // db.Close(); }
public List <ContactData> GetContacts() { using (//в этой конструкции юзинга db.close вызывается автоматически, т.о. мы уменьшаем количество кода 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.Depricated == "0000-00-00 00:00:00") select c).ToList()); } }
public List <ContactData> GetContacts() { AddressBookDB db = new AddressBookDB(); List <ContactData> contactsForGroup = (from c in db.Contacts from gct in db.GroupContactRel.Where(p => p.GroupID == ID && p.ContactID == c.Id && c.Depricated == "0000-00-00 00:00:00") select c).Distinct().ToList(); db.Close(); return(contactsForGroup); }