Exemplo n.º 1
0
        public void CreatesSerialPK()
        {
            var actors   = new SQLDocumentList <Actor>("northwind");
            var newActor = new Actor {
                First_Name = "Joe", Last_Name = "Blow"
            };

            actors.Add(newActor);
            Assert.True(newActor.Actor_ID > 0);
        }
Exemplo n.º 2
0
        public static void Run()
        {
            Console.WriteLine("Connecting to SQL Document Store...");
            var monkies = new SQLDocumentList <Monkey>("northwind");

            monkies.Clear();
            var sw = new Stopwatch();

            sw.Start();
            var addRange = new List <Monkey>();

            for (int i = 0; i < 10000; i++)
            {
                addRange.Add(new Monkey {
                    ID = i, Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
                });
            }
            var inserted = monkies.AddRange(addRange);

            sw.Stop();
            Console.WriteLine("Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);


            Console.WriteLine("Loading 100,000 documents");
            sw.Reset();
            addRange.Clear();
            monkies.Clear();
            sw.Start();
            for (int i = 0; i < 100000; i++)
            {
                addRange.Add(new Monkey {
                    ID = i, Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
                });
            }
            inserted = monkies.AddRange(addRange);
            sw.Stop();
            Console.WriteLine("Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);


            //use a DB that has an int PK
            sw.Reset();
            sw.Start();
            Console.WriteLine("Loading {0}...", inserted);
            monkies.Reload();
            sw.Stop();
            Console.WriteLine("Loaded {0} documents from SQL Server in {1}ms", inserted, sw.ElapsedMilliseconds);

            sw.Reset();
            sw.Start();
            Console.WriteLine("Querying Middle 100 Documents");
            var found = monkies.Where(x => x.ID > 100 && x.ID < 500);

            sw.Stop();
            Console.WriteLine("Queried {0} documents in {1}ms", found.Count(), sw.ElapsedMilliseconds);
        }
Exemplo n.º 3
0
        public void Bulk_Inserts_Documents_With_String_PK()
        {
            int INSERT_QTY = 100;
              var monkies = new SQLDocumentList<MonkeyDocument>("chinook");
              monkies.Clear();

              var addRange = new List<MonkeyDocument>();
              for (int i = 0; i < INSERT_QTY; i++) {
            addRange.Add(new MonkeyDocument { Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back" });
              }
              var inserted = monkies.AddRange(addRange);
              Assert.True(inserted == INSERT_QTY);
        }
Exemplo n.º 4
0
 public SQLServerDocs()
 {
     // Start fresh each time, with no existing table, to keep serial PK's from exploding:
       if(this.TableExists("ClientDocuments")) {
     this.DropTable("ClientDocuments");
       }
       if (this.TableExists("MonkeyDocuments")) {
     this.DropTable("MonkeyDocuments");
       }
       clientDocs = new SQLDocumentList<ClientDocument>(_connectionStringName);
       monkeyDocs = new SQLDocumentList<MonkeyDocument>(_connectionStringName);
       clientDocs.Clear();
 }
Exemplo n.º 5
0
        static void InsertsManyActors()
        {
            var actors   = new SQLDocumentList <Actor>("northwind");
            var bulkList = new List <Actor>();

            for (int i = 0; i < 100; i++)
            {
                var newActor = new Actor {
                    First_Name = "Actor " + i, Last_Name = "Test"
                };
                bulkList.Add(newActor);
            }
            actors.AddRange(bulkList);
            Assert.True(actors.Last().Actor_ID > 90);
        }
Exemplo n.º 6
0
        public void CreatesSerialPK()
        {
            var actors = new SQLDocumentList <Actor>("northwind");

            actors.Clear();
            var newActor = new Actor {
                First_Name = "Joe", Last_Name = "Blow"
            };

            actors.Add(newActor);
            int newId = newActor.Actor_ID;

            actors.Reload();
            Assert.True(actors.Any(a => a.Actor_ID == newId));
        }
Exemplo n.º 7
0
        static void InsertsManyMonkeys()
        {
            int INSERT_QTY = 10000;
            var monkies    = new SQLDocumentList <Monkey>("northwind");

            monkies.Clear();

            var addRange = new List <Monkey>();

            for (int i = 0; i < INSERT_QTY; i++)
            {
                addRange.Add(new Monkey {
                    Name = "MONKEY " + i, Birthday = DateTime.Today, Description = "The Monkey on my back"
                });
            }
            var inserted = monkies.AddRange(addRange);

            Assert.True(inserted == INSERT_QTY && monkies.Count == inserted);
        }
Exemplo n.º 8
0
 public SQLServerDocs()
 {
     docs = new SQLDocumentList <CustomerDocument>("northwind");
     //drop and reload
     docs.Clear();
 }
Exemplo n.º 9
0
        static void Bulk_Inserts_Documents_With_Serial_PK()
        {
            int insertQty = 100;
              var ClientDocuments = new SQLDocumentList<ClientDocument>("chinook");
              var bulkList = new List<ClientDocument>();
              for (int i = 0; i < insertQty; i++) {
            var newClientDocument = new ClientDocument {
              FirstName = "ClientDocument " + i,
              LastName = "Test",
              Email = "*****@*****.**"
            };
            bulkList.Add(newClientDocument);
              }
              int inserted = ClientDocuments.AddRange(bulkList);

              // I have NO IDEA why this silliness suddenly became necessary (the .ToList().Last() bit).
              // This test worked fine last nite. Now says SQLDocumentList<> has no extension Last() JA - 3/12/2014
              Assert.True(inserted == insertQty && ClientDocuments.ToList().Last().ClientDocumentId > insertQty);
        }
Exemplo n.º 10
0
        public static void Run()
        {
            Console.WriteLine("===========================================================");
              Console.WriteLine("SQL SERVER - LOAD A BUNCH OF DOCUMENTS INTO A TABLE");
              Console.WriteLine("===========================================================");

              Console.WriteLine("Connecting to SQL Document Store...");

              // Start clean and fresh . . .
              if (Benchmarks.TableExists("clientdocuments"))
              {
            Benchmarks.DropTable("clientdocuments");
              }

              var _clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
              _clientDocuments.Clear();
              var sw = new Stopwatch();

              var addRange = new List<ClientDocument>();
              for (int i = 0; i < 10000; i++)
              {
            addRange.Add(new ClientDocument
            {
              LastName = "Conery " + i,
              FirstName = "Rob",
              Email = "*****@*****.**"
            });
              }
              sw.Start();
              var inserted = _clientDocuments.AddRange(addRange);
              sw.Stop();
              Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);

              // Start clean and fresh again . . .
              _clientDocuments.Clear();
              addRange.Clear();
              Benchmarks.DropTable("clientdocuments");
              _clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
              sw.Reset();

              Console.WriteLine("Loading 100,000 documents");
              for (int i = 0; i < 100000; i++)
              {
            addRange.Add(new ClientDocument
            {
              LastName = "Conery " + i,
              FirstName = "Rob",
              Email = "*****@*****.**"
            });
              }
              sw.Start();
              inserted = _clientDocuments.AddRange(addRange);
              sw.Stop();
              Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);

              //use a DB that has an int PK
              sw.Reset();
              Console.WriteLine("Loading {0}...", inserted);
              sw.Start();
              _clientDocuments.Reload();
              sw.Stop();
              Console.WriteLine("\t Loaded {0} documents from SQL Server in {1} ms", inserted, sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("Querying Middle 100 Documents");
              sw.Start();
              var found = _clientDocuments.Where(x => x.ClientDocumentId > 100 && x.ClientDocumentId < 500);
              sw.Stop();
              Console.WriteLine("\t Queried {0} documents in {1}ms", found.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("Adds Items in a loop, follows by Bulk Insert");
              if (TableExists("items"))
              {
            DropTable("items");
              }
              sw.Start();
            var list = new List<Item>();
            for (int i = 1; i < 6; i++) {
              list.Add(new Item() {
              Name = "Item no " + i
              });
            }
            var items = new SQLDocumentList<Item>("chinook");
            // 1. Add items in a loop
            foreach (var item in list) {
              items.Add(item);
            }
            // 2. Add items using AddRange...
              items.AddRange(list);
              sw.Stop();
              Console.WriteLine("\t Added {0} items in a loop, then added same items as bullk insert in {1}", list.Count(), sw.ElapsedMilliseconds);
        }
Exemplo n.º 11
0
        public static void Run()
        {
            Console.WriteLine("===========================================================");
              Console.WriteLine("SQL SERVER - LOAD A BUNCH OF DOCUMENTS INTO A TABLE");
              Console.WriteLine("===========================================================");

              Console.WriteLine("Connecting to SQL Document Store...");

              // Start clean and fresh . . .
              if(Benchmarks.TableExists("clientdocuments")) {
            Benchmarks.DropTable("clientdocuments");
              }

              var _clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
              _clientDocuments.Clear();
              var sw = new Stopwatch();

              var addRange = new List<ClientDocument>();
              for (int i = 0; i < 10000; i++) {
            addRange.Add(new ClientDocument {
              LastName = "Conery " + i,
              FirstName = "Rob",
              Email = "*****@*****.**" });
              }
              sw.Start();
              var inserted = _clientDocuments.AddRange(addRange);
              sw.Stop();
              Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);

              // Start clean and fresh again . . .
              _clientDocuments.Clear();
              addRange.Clear();
              Benchmarks.DropTable("clientdocuments");
              _clientDocuments = new SQLDocumentList<ClientDocument>(_connectionStringName);
              sw.Reset();

              Console.WriteLine("Loading 100,000 documents");
              for (int i = 0; i < 100000; i++) {
            addRange.Add(new ClientDocument {
              LastName = "Conery " + i,
              FirstName = "Rob",
              Email = "*****@*****.**"
            });
              }
              sw.Start();
              inserted = _clientDocuments.AddRange(addRange);
              sw.Stop();
              Console.WriteLine("\t Just inserted {0} as documents in {1} ms", inserted, sw.ElapsedMilliseconds);

              //use a DB that has an int PK
              sw.Reset();
              Console.WriteLine("Loading {0}...", inserted);
              sw.Start();
              _clientDocuments.Reload();
              sw.Stop();
              Console.WriteLine("\t Loaded {0} documents from SQL Server in {1} ms", inserted, sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("Querying Middle 100 Documents");
              sw.Start();
              var found = _clientDocuments.Where(x => x.ClientDocumentId > 100 && x.ClientDocumentId < 500);
              sw.Stop();
              Console.WriteLine("\t Queried {0} documents in {1}ms", found.Count(), sw.ElapsedMilliseconds);
        }
Exemplo n.º 12
0
 static void Bulk_Inserts_Documents_With_Serial_PK()
 {
     int insertQty = 100;
       var ClientDocuments = new SQLDocumentList<ClientDocument>("chinook");
       var bulkList = new List<ClientDocument>();
       for (int i = 0; i < insertQty; i++) {
     var newClientDocument = new ClientDocument {
       FirstName = "ClientDocument " + i,
       LastName = "Test",
       Email = "*****@*****.**"
     };
     bulkList.Add(newClientDocument);
       }
       int inserted = ClientDocuments.AddRange(bulkList);
       Assert.True(inserted == insertQty && ClientDocuments.Last().ClientDocumentId > insertQty);
 }