示例#1
0
        /// <summary>
        /// Inserts data with EntityFramework
        /// </summary>
        /// <param name="seed">Randomnumber generators seed</param>
        public static void InsertData(int seedID, int rows)
        {
            try
            {
                var sw = new Stopwatch();

                Console.WriteLine("--Inserting data!");

                sw.Start();

                var i      = 0;
                var result = false;
                var seed   = 0;

                using (var db = new ThesisContext())
                {
                    seed = (from sd in db.Seed
                            where sd.SeedID == seedID
                            select sd.SeedValue).FirstOrDefault();

                    Console.WriteLine("--Seed is : " + seed);

                    var gen = new Random(seed);

                    while (i < rows)
                    {
                        var row = new RandomObject()
                        {
                            RandomObjectID       = i,
                            RandomString         = RandomStringGenerator.RandomString(gen, 15),
                            RandomDateTimeOffset = RandomDateTimeOffsetGenerator.RandomDateTimeOffset(gen),
                            RandomInt            = gen.Next(),
                            SeedID = seedID
                        };

                        db.RandomObject.Add(row);

                        i++;
                    }

                    db.SaveChanges();

                    result = true;

                    sw.Stop();
                }

                Console.WriteLine("--Result was: " + result);
                Console.WriteLine("--Time Elapsed: " + sw.Elapsed + "\n");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Exception occured: " + ex);
                Console.WriteLine("Press any key to continue.");
                Console.ReadKey();
            }
        }
示例#2
0
        /// <summary>
        /// Insert data to table with ADO.Net
        /// </summary>
        /// <param name="seed">Randomnumber generators seed</param>
        public static void InsertData(int seedID, int rows)
        {
            try
            {
                var sw = new Stopwatch();

                Console.WriteLine("--Inserting data!");

                sw.Start();

                var seed             = 0;
                var result           = false;
                var randomObjectList = new List <RandomObjectModel>();

                using (var conn = new SqlConnection(ConnectionString))
                {
                    try
                    {
                        using (SqlCommand cmd = new SqlCommand("SELECT SeedValue FROM Seed WHERE SeedID = @ID", conn))
                        {
                            cmd.Parameters.Add("@ID", SqlDbType.Int).Value = seedID;

                            conn.Open();
                            SqlDataReader reader = cmd.ExecuteReader();

                            while (reader.Read())
                            {
                                seed = (int)reader["SeedValue"];
                            }
                            conn.Close();
                        }
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("Error when fetching Seed!");
                        throw ex;
                    }

                    Console.WriteLine("--Seed is : " + seed);

                    var gen = new Random(seed);
                    var i   = 0;

                    while (i < rows)
                    {
                        using (SqlCommand cmd = new SqlCommand(@"INSERT INTO RandomObject([RandomObjectID], [RandomString], [RandomDateTimeOffset], [RandomInt], [SeedId]) 
                                                             Values(@RandomObjectID, @RandomString, @RandomDateTimeOffset, @RandomInt, @SeedId)", conn))
                        {
                            cmd.Parameters.Add("@RandomObjectID", SqlDbType.Int).Value    = i;
                            cmd.Parameters.Add("@RandomString", SqlDbType.NVarChar).Value = RandomStringGenerator.RandomString(gen, 15);
                            cmd.Parameters.Add("@RandomDateTimeOffset", SqlDbType.DateTimeOffset).Value = RandomDateTimeOffsetGenerator.RandomDateTimeOffset(gen);
                            cmd.Parameters.Add("@RandomInt", SqlDbType.Int).Value = gen.Next();
                            cmd.Parameters.Add("@SeedId", SqlDbType.Int).Value    = seedID;

                            conn.Open();
                            cmd.ExecuteNonQuery();
                            conn.Close();
                            i++;
                        }
                    }

                    result = true;

                    sw.Stop();
                }

                Console.WriteLine("--Result was: " + result);
                Console.WriteLine("--Time Elapsed: " + sw.Elapsed + "\n");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Exception occured: " + ex);
                Console.WriteLine("Press any key to continue.");
                Console.ReadKey();
            }
        }
示例#3
0
        /// <summary>
        /// Insert data to table with Dapper
        /// </summary>
        /// <param name="seed">Randomnumber generators seed</param>
        public static void InsertData(int seedID, int rows)
        {
            try
            {
                var sw = new Stopwatch();

                Console.WriteLine("--Inserting data!");

                sw.Start();

                var i      = 0;
                var result = false;
                var seed   = 0;

                using (var conn = new SqlConnection(ConnectionString))
                {
                    try
                    {
                        seed = conn.Query <int>("SELECT SeedValue FROM Seed WHERE SeedID = @ID", new { ID = seedID }).FirstOrDefault();
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine("Error when fetching Seed!");
                        throw ex;
                    }

                    Console.WriteLine("--Seed is : " + seed);

                    var gen = new Random(seed);

                    while (i < rows)
                    {
                        conn.Execute(@"INSERT INTO RandomObject([RandomObjectID], [RandomString], [RandomDateTimeOffset], [RandomInt], [SeedId]) 
                                                             Values(@RandomObjectID, @RandomString, @RandomDateTimeOffset, @RandomInt, @SeedId)",
                                     new
                        {
                            RandomObjectID       = i,
                            RandomString         = RandomStringGenerator.RandomString(gen, 15),
                            RandomDateTimeOffset = RandomDateTimeOffsetGenerator.RandomDateTimeOffset(gen),
                            RandomInt            = gen.Next(),
                            SeedId = seedID
                        });

                        i++;
                    }

                    result = true;

                    sw.Stop();
                }

                Console.WriteLine("--Result was: " + result);
                Console.WriteLine("--Time Elapsed: " + sw.Elapsed + "\n");
            }
            catch (Exception ex)
            {
                Console.WriteLine("Exception occured: " + ex);
                Console.WriteLine("Press any key to continue.");
                Console.ReadKey();
            }
        }