public void Delete_Customer_In_Customers_Collection(string name, string dbName) { this.Destroy($@"E:\Git\c-sharp-libs\tests\dbs\{dbName}.db"); var localDb = new LocalDb(dbName, @"E:\Git\c-sharp-libs\tests\dbs"); var col = localDb.GetCollection <Customer>(name); col.EnsureIndex(x => x.Name, true); var customer = new Customer { Name = "John Doe", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }; localDb.InsertDocument <Customer>(col, customer); var results = col.Find(x => x.Name == customer.Name); Assert.AreEqual(results.ToArray().Count(), 1); var cust = (Customer)results.ToArray()[0]; localDb.DeleteDocument <Customer>(col, cust._id); var newResults = col.Find(x => x.Name == customer.Name); Assert.AreEqual(newResults.ToArray().Count(), 0); }
public void Bulk_Inserts_Customers_In_Customers_Collection(string name, string dbName) { this.Destroy($@"E:\Git\c-sharp-libs\tests\dbs\{dbName}.db"); var localDb = new LocalDb(dbName, @"E:\Git\c-sharp-libs\tests\dbs"); var col = localDb.GetCollection <Customer>(name); col.EnsureIndex(x => x.Name, true); var customer = new Customer { Name = "John Doe", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }; IEnumerable <Customer> customers() { yield return(customer); yield return(new Customer { Name = "John Doe1", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe2", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe3", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe4", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe5", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe6", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe7", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe8", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); yield return(new Customer { Name = "John Doe9", Phones = new string[] { "8000-0000", "9000-0000" }, Age = 39, IsActive = true }); }; localDb.InsertBulkDocuments <Customer>(col, customers()); var results = col.Find(x => x.Age > 20); Assert.AreEqual(results.ToArray().Count(), 10); }