LiteDB - A .NET NoSQL Document Store in a single data file

LiteDB - A .NET NoSQL Document Store in a single data file

• 1.
  LITEDB - A.NET NOSQL DOCUMENT STORE IN A SINGLE DATA FILE Larry Nung
• 2.
  AGENDA Introduction Installation How to use Reference Q& A 2
• 3.
  INTRODUCTION 3
• 4.
  INTRODUCTION 4
• 5.
  INSTALLATION 5
• 6.
  INSTALLATION  Install-Package LiteDB 6
• 7.
  HOW TO USE 7
• 8.
  OPEN FILE DB 8 … using(var db = new LiteDatabase(dbFile)) { ... }
• 9.
  OPEN NEMORY DB 9 … using(var ms = new MemoryStream(buffer)) using (var db = new LiteDatabase(ms)) { ... }
• 10.
  GET COLLECTION 10 … using (vardb = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); ... }
• 11.
  INSERT DATA 11 … using (vardb = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); var collectionItem = new T(); collection.Insert(collectionItem); }
• 12.
  BATCH INSERT DATA 12 … using(var db = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); collection.InsertBulk(data, batchSize); }
• 13.
  UPDATE DATA 13 … using (vardb = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); var collectionItem.Property = newValue; collection.Update(collectionItem); }
• 14.
  QUERY DATA … using (vardb = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); foreach (var collectionItem in collection.Find(item => item.Property == value)) { … } } 14
• 15.
  QUERY ALL DATA … using(var db = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); foreach (var collectionItem in collection.FindAll()) { … } } 15
• 16.
  SET PROPERTY INDEX … using(var db = new LiteDatabase(dbFile)) { var collection = db.GetCollection<T>(collectionName); ... collection.EnsureIndex(item => item.Property); } 16
• 17.
  UPLOAD FILE … using (vardb = new LiteDatabase(dbFile)) { db.FileStorage.Upload(id, file); } 17
• 18.
  OPEN FILE … using (vardb = new LiteDatabase(dbFile)) { … using (var stream = db.FileStorage.OpenRead(id)) { … } } 18
• 19.
  DOWNLOAD FILE … using (vardb = new LiteDatabase(dbFile)) { … using(var fileStream = File.Create(id)) { fs.Download(id, fileStream); } } 19
• 20.
  REFERENCE 20
• 21.
  REFERENCE  LiteDB ::A .NET embedded NoSQL database  http://www.litedb.org/ 21
• 22.
  Q&A 22
• 23.
  QUESTION & ANSWER 23