public void IdentityKey_UsingReturnValue()
{
Person p = new Person
{
FirstName = "FirstName",
LastName = "LastName",
DateCreated = DateTime.Now,
Active = true
};
Db.Insert(p);
DateTime start = DateTime.Now;
List<int> ids = new List<int>();
for (int i = 0; i < cnt; i++)
{
Person p2 = new Person
{
FirstName = "FirstName" + i,
LastName = "LastName" + i,
DateCreated = DateTime.Now,
Active = true
};
var id = Db.Insert(p2);
ids.Add(id);
}
double total = DateTime.Now.Subtract(start).TotalMilliseconds;
Console.WriteLine("Total Time:" + total);
Console.WriteLine("Average Time:" + total / cnt);
}
public void AddsEntityToDatabase_ReturnsKey()
{
Person p = new Person { Active = true, FirstName = "Foo", LastName = "Bar", DateCreated = DateTime.UtcNow };
int id = Db.Insert(p);
Assert.AreEqual(1, id);
Assert.AreEqual(1, p.Id);
}
public void Eq_EnumerableType_GeneratesAndRunsProperSql()
{
Person p1 = new Person { Active = true, FirstName = "Alpha", LastName = "Bar", DateCreated = DateTime.UtcNow };
Person p2 = new Person { Active = true, FirstName = "Beta", LastName = "Bar", DateCreated = DateTime.UtcNow };
Person p3 = new Person { Active = true, FirstName = "Gamma", LastName = "Bar", DateCreated = DateTime.UtcNow };
Impl.Insert<Person>(Connection, new[] { p1, p2, p3 }, null, null);
var predicate = Predicates.Field<Person>(p => p.FirstName, Operator.Eq, new[] { "Alpha", "Gamma" });
var result = Impl.GetList<Person>(Connection, predicate, null, null, null, true);
Assert.AreEqual(2, result.Count());
Assert.IsTrue(result.Any(r => r.FirstName == "Alpha"));
Assert.IsTrue(result.Any(r => r.FirstName == "Gamma"));
}
public void Between_GeneratesAndRunsProperSql()
{
Person p1 = new Person { Active = true, FirstName = "Alpha", LastName = "Bar", DateCreated = DateTime.UtcNow };
Person p2 = new Person { Active = true, FirstName = "Beta", LastName = "Bar", DateCreated = DateTime.UtcNow };
Person p3 = new Person { Active = true, FirstName = "Gamma", LastName = "Omega", DateCreated = DateTime.UtcNow };
Impl.Insert<Person>(Connection, new[] { p1, p2, p3 }, null, null);
var pred = Predicates.Between<Person>(p => p.LastName,
new BetweenValues { Value1 = "Aaa", Value2 = "Bzz" });
var result = Impl.GetList<Person>(Connection, pred, null, null, null, true).ToList();
Assert.AreEqual(2, result.Count);
Assert.AreEqual("Alpha", result[0].FirstName);
Assert.AreEqual("Beta", result[1].FirstName);
}
public void UsingKey_ReturnsEntity()
{
Person p1 = new Person
{
Active = true,
FirstName = "Foo",
LastName = "Bar",
DateCreated = DateTime.UtcNow
};
int id = Db.Insert(p1);
Person p2 = Db.Get<Person>(id);
Assert.AreEqual(id, p2.Id);
Assert.AreEqual("Foo", p2.FirstName);
Assert.AreEqual("Bar", p2.LastName);
}
public void Exists_GeneratesAndRunsProperSql()
{
Person p1 = new Person { Active = true, FirstName = "Alpha", LastName = "Bar", DateCreated = DateTime.UtcNow };
Person p2 = new Person { Active = true, FirstName = "Beta", LastName = "Bar", DateCreated = DateTime.UtcNow };
Person p3 = new Person { Active = true, FirstName = "Gamma", LastName = "Bar", DateCreated = DateTime.UtcNow };
Impl.Insert<Person>(Connection, new[] { p1, p2, p3 }, null, null);
Animal a1 = new Animal { Name = "Gamma" };
Animal a2 = new Animal { Name = "Beta" };
Impl.Insert<Animal>(Connection, new[] { a1, a2 }, null, null);
var subPredicate = Predicates.Property<Person, Animal>(p => p.FirstName, Operator.Eq, a => a.Name);
var predicate = Predicates.Exists<Animal>(subPredicate);
var result = Impl.GetList<Person>(Connection, predicate, null, null, null, true);
Assert.AreEqual(2, result.Count());
Assert.IsTrue(result.Any(r => r.FirstName == "Beta"));
Assert.IsTrue(result.Any(r => r.FirstName == "Gamma"));
}
public void UsingKey_DeletesFromDatabase()
{
Person p1 = new Person
{
Active = true,
FirstName = "Foo",
LastName = "Bar",
DateCreated = DateTime.UtcNow
};
int id = Db.Insert(p1);
Person p2 = Db.Get<Person>(id);
Db.Delete(p2);
Assert.IsNull(Db.Get<Person>(id));
}
public void UsingKey_UpdatesEntity()
{
Person p1 = new Person
{
Active = true,
FirstName = "Foo",
LastName = "Bar",
DateCreated = DateTime.UtcNow
};
int id = Db.Insert(p1);
var p2 = Db.Get<Person>(id);
p2.FirstName = "Baz";
p2.Active = false;
Db.Update(p2);
var p3 = Db.Get<Person>(id);
Assert.AreEqual("Baz", p3.FirstName);
Assert.AreEqual("Bar", p3.LastName);
Assert.AreEqual(false, p3.Active);
}
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());
}