Пример #1
0
 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 c in db.Contacts where c.Deprecated == "0000-00-00 00:00:00" select c).ToList());
     };
 }
Пример #3
0
        public void TestConnectionDB_2()
        {
            //берем данные с UI
            var start  = DateTime.Now;
            var fromUI = app.Groups.GetGroupCashListOptimize();
            var end    = DateTime.Now;

            System.Console.Out.WriteLine(end.Subtract(start));

            //берем данные с BD
            start = DateTime.Now;
            using (var db = new AddressBookDB())
            {
                var fromDB = (from g in db.Groups select g).ToList();
            }
            end = DateTime.Now;
            System.Console.Out.WriteLine(end.Subtract(start));
        }
Пример #4
0
        public void TestConnectionDB()
        {
            //берем данные с UI
            DateTime         start  = DateTime.Now;
            List <GroupData> fromUI = app.Groups.GetGroupCashListOptimize();
            DateTime         end    = DateTime.Now;

            System.Console.Out.WriteLine(end.Subtract(start));

            //берем данные с BD
            start = DateTime.Now;
            AddressBookDB    db     = new AddressBookDB();
            List <GroupData> fromDB = (from g in db.Groups select g).ToList();

            db.Close();
            end = DateTime.Now;
            System.Console.Out.WriteLine(end.Subtract(start));
        }