public void UsingKey_UpdatesEntity()
{
var p1 = new Person
{
Active = "Y",
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 = "N";
Db.Update(p2);
var p3 = Db.Get <Person>(id).Result;
Assert.AreEqual("Baz", p3.FirstName);
Assert.AreEqual("Bar", p3.LastName);
Assert.AreEqual("N", p3.Active);
Dispose();
}
public void UsingObject_DeletesRows()
{
Person p1 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
Person p2 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
Person p3 = new Person {
Active = "Y", 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());
Dispose();
}
public void UsingPredicate_DeletesRows()
{
Person p1 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
Person p2 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
Person p3 = new Person {
Active = "Y", 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());
Dispose();
}
public void AddsEntityToDatabase_ReturnsKey()
{
var p = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
var id = Db.Insert(p).Result;
Assert.AreEqual(1, id);
Assert.AreEqual(1, p.Id);
Dispose();
}
private static void Arrange(out Person p1, out Person p2, out Person p3)
{
p1 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
p2 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow
};
p3 = new Person {
Active = "Y", FirstName = "Foo", LastName = "Barz", DateCreated = DateTime.UtcNow
};
}
public void UsingKey_DeletesFromDatabase()
{
Person p1 = new Person
{
Active = "Y",
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));
Dispose();
}
public void UsingKey_ReturnsEntity()
{
var p1 = new Person
{
Active = "Y",
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);
Dispose();
}
