public SqliteChinookDb(string connectionstringName, bool dropCreateTables = false) { _db = new SqliteDbCore(connectionstringName); if (dropCreateTables) { this.DropCreateAll(); } this.LoadData(); }
public SqliteTruncDb(string dbDirectory, bool forceDropCreateTables = false) { const string databaseName = "data.db"; // Initialize database if it hasn't been created yet if (!File.Exists(Path.Combine(dbDirectory, databaseName))) { forceDropCreateTables = true; } _db = new SqliteDbCore(dbDirectory, databaseName); DropCreateAll(forceDropCreateTables); LoadData(); }
public void init() { _db = new SqliteDbCore("BiggyTestSQLiteRelational"); _filename = _db.DBFilePath; DropCreateTestTables(); }
public void init() { _db = new SqliteDbCore("BiggyTestSQLiteDocuments"); _filename = _db.DBFilePath; }
public void init() { _db = new SqliteDbCore("BiggyTestSQLiteRelational"); _filename = _db.DBFilePath; DropCreateTestTables(); }
public void init() { _db = new SqliteDbCore("BiggyTestSQLiteDocuments"); _filename = _db.DBFilePath; }
public void Run() { Console.WriteLine("SQLite Relational Demo - TEST DATA"); Console.WriteLine("===================================="); Console.WriteLine("Initialize Test Db"); var sw = new Stopwatch(); sw.Start(); _testDb = new SqliteChinookDb("BiggyTest", dropCreateTables: true); sw.Stop(); Console.WriteLine("Initialized and reset SQLite database in {0} MS", sw.ElapsedMilliseconds); Console.WriteLine("Write some test data..."); var sampleArtists = SampleData.GetSampleArtists(qty: 1000); var sampleAlbums = SampleData.GetSampleAlbums(qtyPerArtist: 3); var sampleTracks = SampleData.GetSampleTracks(qtyPerAlbum: 8); sw.Reset(); sw.Start(); _testDb.Artists.Add(sampleArtists); sw.Stop(); Console.WriteLine("Wrote {0} artist records in {1} ms", sampleArtists.Count, sw.ElapsedMilliseconds); sw.Reset(); sw.Start(); _testDb.Albums.Add(sampleAlbums); sw.Stop(); Console.WriteLine("Wrote {0} album records in {1} ms", sampleAlbums.Count, sw.ElapsedMilliseconds); sw.Reset(); sw.Start(); _testDb.Tracks.Add(sampleTracks); sw.Stop(); Console.WriteLine("Wrote {0} track records in {1} ms", sampleTracks.Count, sw.ElapsedMilliseconds); Console.WriteLine(""); Console.WriteLine("Re-Initialize Db and read all that data from back-end..."); Console.WriteLine(""); sw.Reset(); sw.Start(); _testDb.LoadData(); sw.Stop(); Console.WriteLine("Read all data from store in {0} ms", sw.ElapsedMilliseconds); Console.WriteLine("{0} Artists", _testDb.Artists.Count); Console.WriteLine("{0} Albums", _testDb.Albums.Count); Console.WriteLine("{0} Tracks", _testDb.Tracks.Count); Console.WriteLine("Update a whole bunch of artist records..."); var updateArtists = _testDb.Artists.ToList(); foreach (var artist in updateArtists) { artist.Name = "Updated Artist " + artist.ArtistId; } sw.Reset(); sw.Start(); _testDb.Artists.Update(updateArtists); sw.Stop(); Console.WriteLine("Updated {0} artist records in {1} ms", updateArtists.Count, sw.ElapsedMilliseconds); Console.WriteLine(""); Console.WriteLine("SQLite Relational Demo - CHINOOK DATA"); Console.WriteLine("======================================="); Console.WriteLine("Now let's use some actual data from Chinook Db..."); sw.Reset(); sw.Start(); _chinookDb = new SqliteChinookDb("Chinook"); var _tempDb = new SqliteDbCore("Chinook"); var _tempStore = new SqliteRelationalStore <Artist>(_tempDb); var tempArtists = _tempStore.TryLoadData(); sw.Stop(); Console.WriteLine("Initialized Chinook data in {0} ms - loaded:", sw.ElapsedMilliseconds); Console.WriteLine("{0} Artists", _chinookDb.Artists.Count); Console.WriteLine("{0} Albums", _chinookDb.Albums.Count); Console.WriteLine("{0} Tracks", _chinookDb.Tracks.Count); Console.WriteLine(""); Console.WriteLine("Some fancy Querying - CHINOOK DATA"); Console.WriteLine("=================================="); Console.WriteLine(""); Console.WriteLine("Find all albums by a particular Artist using LINQ join"); string artistToFind = "Metallica"; sw.Reset(); sw.Start(); var artistAlbums = (from a in _chinookDb.Albums join ar in _chinookDb.Artists on a.ArtistId equals ar.ArtistId where ar.Name == artistToFind select a).ToList(); // We use .ToList() because the objects aren't enumerated until used - we want a rough perf measurement to fetch the objects. sw.Stop(); Console.WriteLine("\tArtist: {0}:", artistToFind); foreach (var album in artistAlbums) { Console.WriteLine("\t -{0}", album.Title); } Console.WriteLine("Found {0} albums for {1} out of {2} in {3} ms", artistAlbums.Count(), artistToFind, _chinookDb.Albums.Count, sw.ElapsedMilliseconds); Console.WriteLine(""); Console.WriteLine("Find all tracks by a particular Artist using triple LINQ join"); artistToFind = "AC/DC"; sw.Reset(); sw.Start(); var artistTracks = (from t in _chinookDb.Tracks join al in _chinookDb.Albums on t.AlbumId equals al.AlbumId join ar in _chinookDb.Artists on al.ArtistId equals ar.ArtistId where ar.Name == artistToFind select t).ToList(); Console.WriteLine("\tArtist: {0}:", artistToFind); foreach (var track in artistTracks) { Console.WriteLine("\t -{0}", track.Name); } Console.WriteLine("Found {0} tracks for {1} from {2} albums among {3} total tracks in {4} ms", artistTracks.Count(), artistToFind, _chinookDb.Albums.Count, _chinookDb.Tracks.Count, sw.ElapsedMilliseconds); }
public void init() { _db = new SqliteDbCore("BiggyTest"); _db.TryDropTable("propertydocuments"); _PropertyDocumentStore = _db.CreateDocumentStoreFor<PropertyDocument>(); }
public void init() { _db = new SqliteDbCore("BiggyTest"); DropCreateTestTables(); _propertyStore = _db.CreateRelationalStoreFor <Property>(); }
public void Run() { Console.WriteLine("SQLite Relational Demo - TEST DATA"); Console.WriteLine("===================================="); Console.WriteLine("Initialize Test Db"); var sw = new Stopwatch(); sw.Start(); _testDb = new SqliteChinookDb("BiggyTest", dropCreateTables: true); sw.Stop(); Console.WriteLine("Initialized and reset SQLite database in {0} MS", sw.ElapsedMilliseconds); Console.WriteLine("Write some test data..."); var sampleArtists = SampleData.GetSampleArtists(qty: 1000); var sampleAlbums = SampleData.GetSampleAlbums(qtyPerArtist: 3); var sampleTracks = SampleData.GetSampleTracks(qtyPerAlbum: 8); sw.Reset(); sw.Start(); _testDb.Artists.Add(sampleArtists); sw.Stop(); Console.WriteLine("Wrote {0} artist records in {1} ms", sampleArtists.Count, sw.ElapsedMilliseconds); sw.Reset(); sw.Start(); _testDb.Albums.Add(sampleAlbums); sw.Stop(); Console.WriteLine("Wrote {0} album records in {1} ms", sampleAlbums.Count, sw.ElapsedMilliseconds); sw.Reset(); sw.Start(); _testDb.Tracks.Add(sampleTracks); sw.Stop(); Console.WriteLine("Wrote {0} track records in {1} ms", sampleTracks.Count, sw.ElapsedMilliseconds); Console.WriteLine(""); Console.WriteLine("Re-Initialize Db and read all that data from back-end..."); Console.WriteLine(""); sw.Reset(); sw.Start(); _testDb.LoadData(); sw.Stop(); Console.WriteLine("Read all data from store in {0} ms", sw.ElapsedMilliseconds); Console.WriteLine("{0} Artists", _testDb.Artists.Count); Console.WriteLine("{0} Albums", _testDb.Albums.Count); Console.WriteLine("{0} Tracks", _testDb.Tracks.Count); Console.WriteLine("Update a whole bunch of artist records..."); var updateArtists = _testDb.Artists.ToList(); foreach (var artist in updateArtists) { artist.Name = "Updated Artist " + artist.ArtistId; } sw.Reset(); sw.Start(); _testDb.Artists.Update(updateArtists); sw.Stop(); Console.WriteLine("Updated {0} artist records in {1} ms", updateArtists.Count, sw.ElapsedMilliseconds); Console.WriteLine(""); Console.WriteLine("SQLite Relational Demo - CHINOOK DATA"); Console.WriteLine("======================================="); Console.WriteLine("Now let's use some actual data from Chinook Db..."); sw.Reset(); sw.Start(); _chinookDb = new SqliteChinookDb("Chinook"); var _tempDb = new SqliteDbCore("Chinook"); var _tempStore = new SqliteRelationalStore<Artist>(_tempDb); var tempArtists = _tempStore.TryLoadData(); sw.Stop(); Console.WriteLine("Initialized Chinook data in {0} ms - loaded:", sw.ElapsedMilliseconds); Console.WriteLine("{0} Artists", _chinookDb.Artists.Count); Console.WriteLine("{0} Albums", _chinookDb.Albums.Count); Console.WriteLine("{0} Tracks", _chinookDb.Tracks.Count); Console.WriteLine(""); Console.WriteLine("Some fancy Querying - CHINOOK DATA"); Console.WriteLine("=================================="); Console.WriteLine(""); Console.WriteLine("Find all albums by a particular Artist using LINQ join"); string artistToFind = "Metallica"; sw.Reset(); sw.Start(); var artistAlbums = (from a in _chinookDb.Albums join ar in _chinookDb.Artists on a.ArtistId equals ar.ArtistId where ar.Name == artistToFind select a).ToList(); // We use .ToList() because the objects aren't enumerated until used - we want a rough perf measurement to fetch the objects. sw.Stop(); Console.WriteLine("\tArtist: {0}:", artistToFind); foreach (var album in artistAlbums) { Console.WriteLine("\t -{0}", album.Title); } Console.WriteLine("Found {0} albums for {1} out of {2} in {3} ms", artistAlbums.Count(), artistToFind, _chinookDb.Albums.Count, sw.ElapsedMilliseconds); Console.WriteLine(""); Console.WriteLine("Find all tracks by a particular Artist using triple LINQ join"); artistToFind = "AC/DC"; sw.Reset(); sw.Start(); var artistTracks = (from t in _chinookDb.Tracks join al in _chinookDb.Albums on t.AlbumId equals al.AlbumId join ar in _chinookDb.Artists on al.ArtistId equals ar.ArtistId where ar.Name == artistToFind select t).ToList(); Console.WriteLine("\tArtist: {0}:", artistToFind); foreach (var track in artistTracks) { Console.WriteLine("\t -{0}", track.Name); } Console.WriteLine("Found {0} tracks for {1} from {2} albums among {3} total tracks in {4} ms", artistTracks.Count(), artistToFind, _chinookDb.Albums.Count, _chinookDb.Tracks.Count, sw.ElapsedMilliseconds); }
public void init() { _db = new SqliteDbCore("BiggyTest"); _db.TryDropTable("propertydocuments"); _PropertyDocumentStore = _db.CreateDocumentStoreFor <PropertyDocument>(); }
public void init() { _db = new SqliteDbCore("BiggyTest"); DropCreateTestTables(); _propertyStore = _db.CreateRelationalStoreFor<Property>(); }