public void Inserts_record_with_int_id() { _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore<WidgetDocuments>(_db); var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" }; widgetstore.Add(newWidget); var foundWidget = widgetstore.TryLoadData().FirstOrDefault(); Assert.IsTrue(foundWidget != null && foundWidget.Identifier == 100); }
public void Updates_record_with_int_id() { _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore<WidgetDocuments>(_db); var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" }; widgetstore.Add(newWidget); // Now go fetch the record again and update: string newCategory = "Gold"; var foundWidget = widgetstore.TryLoadData().FirstOrDefault(); foundWidget.Category = newCategory; widgetstore.Update(foundWidget); Assert.IsTrue(foundWidget != null && foundWidget.Category == newCategory); }
public void Inserts_record_with_int_id() { _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db); var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" }; widgetstore.Add(newWidget); var foundWidget = widgetstore.TryLoadData().FirstOrDefault(); Assert.IsTrue(foundWidget != null && foundWidget.Identifier == 100); }
public void Updates_record_with_int_id() { _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db); var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" }; widgetstore.Add(newWidget); // Now go fetch the record again and update: string newCategory = "Gold"; var foundWidget = widgetstore.TryLoadData().FirstOrDefault(); foundWidget.Category = newCategory; widgetstore.Update(foundWidget); Assert.IsTrue(foundWidget != null && foundWidget.Category == newCategory); }
public void Deletes_record_with_int_id() { _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore <WidgetDocuments>(_db); var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" }; widgetstore.Add(newWidget); // Load from back-end: var companies = widgetstore.TryLoadData(); int qtyAdded = companies.Count; // Delete: var foundWidget = companies.FirstOrDefault(); widgetstore.Delete(foundWidget); int remaining = widgetstore.TryLoadData().Count; Assert.IsTrue(qtyAdded == 1 && remaining == 0); }
public void Deletes_record_with_int_id() { _db.TryDropTable("widgetdocuments"); var widgetstore = new SqliteDocumentStore<WidgetDocuments>(_db); var newWidget = new WidgetDocuments { Identifier = 100, Category = "Brass" }; widgetstore.Add(newWidget); // Load from back-end: var companies = widgetstore.TryLoadData(); int qtyAdded = companies.Count; // Delete: var foundWidget = companies.FirstOrDefault(); widgetstore.Delete(foundWidget); int remaining = widgetstore.TryLoadData().Count; Assert.IsTrue(qtyAdded == 1 && remaining == 0); }