Exemple #1
0
        public void _Writes_large_DataSet_to_Memory()
        {
            if (_transactions.Count() > 0)
            {
                _transactions.Clear();
            }
            var data = _setup.getSkinnyTransactionSet(_qtyCrapTons);

            // TODO: Should the flush back to the Db be implicit, or explicit?
            // It is currently implicit, and happens automatically. Maybe change this.
            _transactions.AddRange(data);
            Assert.True(_transactions.Count == _qtyCrapTons);
        }
Exemple #2
0
        public static void Run()
        {
            var sw = new Stopwatch();

            Console.WriteLine("Loading up tracks from Chinook...");
            sw.Start();
            //use the dvds db
            var films = new SQLServerList <Track>("chinook", "track", "trackid");

            sw.Stop();
            Console.WriteLine("Loaded {0} records in {1}ms", films.Count(), sw.ElapsedMilliseconds);
        }
Exemple #3
0
 public void _Loads_Empty_List_Into_Memory()
 {
     _transactions = new SQLServerList <Transaction>(_connectionStringName, _testTableName, _tablePkColumn);
     Assert.True(_transactions != null && _transactions.Count() == 0);
 }
Exemple #4
0
        public static void Run()
        {
            var sw = new Stopwatch();
              Console.WriteLine("===========================================================");
              Console.WriteLine("SQL SERVER - SOME FANCY QUERYING");
              Console.WriteLine("===========================================================");

              Console.WriteLine("Loading up Artists from Chinook...");
              sw.Start();
              var _artists = new SQLServerList<Artist>(_connectionStringName, "artist");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} Artist records in {1} ms", _artists.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Loading up Albums from Chinook...");
              sw.Reset();
              sw.Start();
              var _albums = new SQLServerList<Album>(_connectionStringName, "album");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} Albums in {1} ms", _artists.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Loading up tracks from Chinook...");
              sw.Reset();
              sw.Start();
              var _tracks = new SQLServerList<Track>(_connectionStringName, "track");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} Tracks in {1} ms", _tracks.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Grab the record for AC/DC...");
              sw.Reset();
              sw.Start();
              var acdc = _artists.FirstOrDefault(a => a.Name == "AC/DC");
              sw.Stop();
              Console.WriteLine("\tFound AC/DC from memory in {0} ms", sw.ElapsedMilliseconds);

              Console.WriteLine("Find all the albums by AC/DC ...");
              sw.Reset();
              sw.Start();
              var acdcAlbums = _albums.Where(a => a.ArtistId == acdc.ArtistId);
              sw.Stop();
              Console.WriteLine("\tFound All {0} AC/DC albums from memory in {1} ms", acdcAlbums.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine("Find all the Tracks from Albums by AC/DC ...");
              sw.Reset();
              sw.Start();
              var acdcTracks = from t in _tracks
                       join a in acdcAlbums on t.AlbumId equals a.AlbumId
                       select t;
              sw.Stop();
              Console.WriteLine("\tFound All {0} tracks by ACDC using in-memory JOIN in {1} ms:", acdcTracks.Count(), sw.ElapsedMilliseconds);
              foreach (var track in acdcTracks)
              {
            Console.WriteLine("\t-{0}", track.Name);
              }
              Console.WriteLine(Environment.NewLine);
              Console.WriteLine("===========================================================");
              Console.WriteLine("SQL SERVER - BASIC CRUD OPERATIONS");
              Console.WriteLine("===========================================================");

              sw.Reset();
              Console.WriteLine("Loading up customers from Chinook...");
              sw.Start();
              var customers = new SQLServerList<Customer>(_connectionStringName, "customer");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} records in {1}ms", customers.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("INSERTING a NEW Customer into Chinook...");
              var newCustomer = new Customer() { LastName = "Atten", FirstName = "John", Email = "*****@*****.**" };
              sw.Start();
              customers.Add(newCustomer);
              sw.Stop();
              Console.WriteLine("\tWrote 1 record for a new count of {0} records in {1} ms", customers.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("UPDATING the new Customer record in Chinook...");
              newCustomer.FirstName = "Fred";
              sw.Start();
              customers.Update(newCustomer);
              sw.Stop();
              Console.WriteLine("\tUpdated 1 record for a new count of {0} records in {1} ms", customers.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("DELETE the new Customer record in Chinook...");
              sw.Start();
              customers.Remove(newCustomer);
              sw.Stop();
              Console.WriteLine("\tDeleted 1 record for a new count of {0} records in {1} ms", customers.Count(), sw.ElapsedMilliseconds);

              Console.WriteLine(Environment.NewLine);
              Console.WriteLine("===========================================================");
              Console.WriteLine("SQL SERVER - BULK INSERTS AND DELETIONS");
              Console.WriteLine("===========================================================");

              Console.WriteLine("Creating Test Table...");
            Benchmarks.SetUpClientTable();

              sw.Reset();
              int INSERT_QTY = 10000;
              Console.WriteLine("BULK INSERTING  {0} client records in Chinook...", INSERT_QTY);
              var _clients = new SQLServerList<Client>(_connectionStringName, "Clients");

              var inserts = new List<Client>();
              for (int i = 0; i < INSERT_QTY; i++) {
            inserts.Add(new Client() { LastName = string.Format("Atten {0}", i.ToString()), FirstName = "John", Email = "*****@*****.**" });
              }
              sw.Start();
              var inserted = _clients.AddRange(inserts);
              sw.Stop();
              Console.WriteLine("\tInserted {0} records in {1} ms", inserted, sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("Loading up Bulk inserted CLients from Chinook...");
              sw.Start();
              _clients = new SQLServerList<Client>(_connectionStringName, "clients");
              sw.Stop();
              Console.WriteLine("\tLoaded {0} records in {1}ms", _clients.Count(), sw.ElapsedMilliseconds);

              sw.Reset();
              Console.WriteLine("DELETING added records from Chinook...");
              var toRemove = _clients.Where(x => x.Email == "*****@*****.**");
              sw.Start();
              int removed = _clients.RemoveSet(toRemove);
              sw.Stop();
              Console.WriteLine("\tDeleted {0} records in {1}ms", removed, sw.ElapsedMilliseconds);
        }