public void UsingObject_DeletesRows() { Person p1 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; Person p2 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; Person p3 = new Person { Active = true, FirstName = "Foo", LastName = "Barz", DateCreated = DateTime.UtcNow }; Db.Insert(p1); Db.Insert(p2); Db.Insert(p3); var list = Db.GetList <Person>(); Assert.AreEqual(3, list.Count()); var result = Db.Delete <Person>(new { LastName = "Bar" }); Assert.IsTrue(result); list = Db.GetList <Person>(); Assert.AreEqual(1, list.Count()); }
public void UsingPredicate_DeletesRows() { Person p1 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; Person p2 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; Person p3 = new Person { Active = true, FirstName = "Foo", LastName = "Barz", DateCreated = DateTime.UtcNow }; Db.Insert(p1); Db.Insert(p2); Db.Insert(p3); var list = Db.GetList <Person>(); Assert.AreEqual(3, list.Count()); IPredicate pred = Predicates.Field <Person>(p => p.LastName, Operator.Eq, "Bar"); var result = Db.Delete <Person>(pred); Assert.IsTrue(result); list = Db.GetList <Person>(); Assert.AreEqual(1, list.Count()); }
public void AddsEntityToDatabase_ReturnsKey() { var p = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; var id = Db.Insert(p).Result; Assert.AreEqual(1, id); Assert.AreEqual(1, p.Id); }
private static void Arrange(out Person p1, out Person p2, out Person p3) { p1 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; p2 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; p3 = new Person { Active = true, FirstName = "Foo", LastName = "Barz", DateCreated = DateTime.UtcNow }; }
public void UsingKey_DeletesFromDatabase() { Person p1 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; var id = Db.Insert(p1); Person p2 = Db.Get <Person>(id); Db.Delete(p2); Assert.IsNull(Db.Get <Person>(id)); }
public void UsingKey_ReturnsEntity() { var p1 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; var id = Db.Insert(p1).Result; var p2 = Db.Get <Person>(id).Result; Assert.AreEqual(id, p2.Id); Assert.AreEqual("Foo", p2.FirstName); Assert.AreEqual("Bar", p2.LastName); }
public void UsingKey_UpdatesEntity() { var p1 = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow }; var id = Db.Insert(p1).Result; var p2 = Db.Get <Person>(id).Result; p2.FirstName = "Baz"; p2.Active = false; Db.Update(p2); var p3 = Db.Get <Person>(id).Result; Assert.AreEqual("Baz", p3.FirstName); Assert.AreEqual("Bar", p3.LastName); Assert.AreEqual(false, p3.Active); }