public void AddsEntityToDatabase_ReturnsGeneratedPrimaryKey()
{
Animal a1 = new Animal { Name = "Foo" };
Db.Insert(a1);
var a2 = Db.Get<Animal>(a1.Id);
Assert.AreNotEqual(Guid.Empty, a2.Id);
Assert.AreEqual(a1.Id, a2.Id);
}
public void AddsMultipleEntitiesToDatabase()
{
Animal a1 = new Animal { Name = "Foo" };
Animal a2 = new Animal { Name = "Bar" };
Animal a3 = new Animal { Name = "Baz" };
Db.Insert<Animal>(new[] { a1, a2, a3 });
var animals = Db.GetList<Animal>().ToList();
Assert.AreEqual(3, animals.Count);
}
public void GuidKey_UsingEntity()
{
Animal a = new Animal { Name = "Name" };
Db.Insert(a);
DateTime start = DateTime.Now;
List<Guid> ids = new List<Guid>();
for (int i = 0; i < cnt; i++)
{
Animal a2 = new Animal { Name = "Name" + i };
Db.Insert(a2);
ids.Add(a2.Id);
}
double total = DateTime.Now.Subtract(start).TotalMilliseconds;
Console.WriteLine("Total Time:" + total);
Console.WriteLine("Average Time:" + total / cnt);
}
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 AddsMultipleEntitiesToDatabase_WithPassedInGuid()
{
var guid1 = Guid.NewGuid();
Animal a1 = new Animal { Id = guid1, Name = "Foo" };
var guid2 = Guid.NewGuid();
Animal a2 = new Animal { Id = guid2, Name = "Bar" };
var guid3 = Guid.NewGuid();
Animal a3 = new Animal { Id = guid3, Name = "Baz" };
Db.Insert<Animal>(new[] { a1, a2, a3 });
var animals = Db.GetList<Animal>().ToList();
Assert.AreEqual(3, animals.Count);
Assert.IsNotNull(animals.FirstOrDefault(x => x.Id == guid1));
Assert.IsNotNull(animals.FirstOrDefault(x => x.Id == guid2));
Assert.IsNotNull(animals.FirstOrDefault(x => x.Id == guid3));
}
public void AddsEntityToDatabase_WithPassedInGuid()
{
var guid = Guid.NewGuid();
Animal a1 = new Animal { Id = guid, Name = "Foo" };
Db.Insert(a1);
var a2 = Db.Get<Animal>(a1.Id);
Assert.AreNotEqual(Guid.Empty, a2.Id);
Assert.AreEqual(guid, a2.Id);
}
