public void Update_all_one_success() { var query = Prepare.SetQuery(); var allProperty = Prepare.GetQuery().GetFirst(a => a.Id == 7); allProperty.index = DateTime.Now.Day; allProperty.description = $"Updated on {DateTime.Now}"; allProperty.datemod = DateTime.Now; allProperty.amount = DateTime.Now.DayOfYear; var result = query.Update(allProperty); Assert.True(result); var oneProperty = Prepare.GetQuery().GetFirst(a => a.Id == 9); oneProperty.index = DateTime.Now.Day; oneProperty.description = $"Updated on {DateTime.Now}"; oneProperty.datemod = DateTime.Now; oneProperty.amount = DateTime.Now.DayOfYear; result = query.Update(oneProperty, p => p.description); Assert.True(result); }
public void Insert_Delete_success() { var query = Prepare.SetQuery(); var result = query.Insert(new Author { index = 99, Name = "New insert", amount = 88, datemod = DateTime.Now }); Assert.True(result); result = query.Delete(a => a.index == 99); Assert.True(result); }
public void InsertBulk_success() { var query = Prepare.SetQuery(); var newList = new List <Author> { new Author { index = DateTime.Now.Day, description = $"Inserted (1) on {DateTime.Now}", datemod = DateTime.Now, amount = DateTime.Now.DayOfYear }, new Author { index = DateTime.Now.Day, description = $"Inserted (2) on {DateTime.Now}", datemod = DateTime.Now, amount = DateTime.Now.DayOfYear } }; var result = query.InsertBulk(newList); Assert.True(result); }