Ejemplo n.º 1
0
        public TimeSpan createQueries(int count)
        {
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();
            int max = 1000;

            using (var connection = new EFHandler())
            {
                List <User> users = new List <User>();
                for (int idx = 0; idx < count; idx++)
                {
                    User user = new User()
                    {
                        email = "*****@*****.**", created_at = DateTime.Now
                    };
                    users.Add(user);
                    connection.users.Add(user);
                    if (idx % max == 0 || idx == (count - 1))
                    {
                        connection.SaveChanges();
                        foreach (User user2 in users)
                        {
                            connection.Entry(user2).State = EntityState.Detached;
                        }
                        users.Clear();
                    }
                }
            }
            stopWatch.Stop();
            return(stopWatch.Elapsed);
        }
Ejemplo n.º 2
0
        public EF()
        {
            startingComments();
            efHandler = new EFHandler();

            inserting();
            selecting();
            updating();
            deleting();
        }
Ejemplo n.º 3
0
        public int countRows()
        {
            int amount = 0;

            using (var connection = new EFHandler())
            {
                amount = connection.users.Count();
            }
            return(amount);
        }
Ejemplo n.º 4
0
        public TimeSpan selectQueries(int count)
        {
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();

            using (var connection = new EFHandler())
            {
                List <User> users = connection.users.Take(count).ToList();
            }
            stopWatch.Stop();
            return(stopWatch.Elapsed);
        }
Ejemplo n.º 5
0
        public TimeSpan updateQueries(int count)
        {
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();

            using (var connection = new EFHandler())
            {
                List <User> users = connection.users.Take(count).ToList();
                foreach (User user in users)
                {
                    user.failedLoginAttempts = 1;
                }
                connection.SaveChanges();
            }
            stopWatch.Stop();
            return(stopWatch.Elapsed);
        }
Ejemplo n.º 6
0
        public TimeSpan deleteQueries(int count)
        {
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();

            using (var connection = new EFHandler())
            {
                List <User> users = connection.users.Take(count).ToList();
                foreach (User user in users)
                {
                    connection.users.Remove(user);
                }
                connection.SaveChanges();
            }
            stopWatch.Stop();
            return(stopWatch.Elapsed);
        }