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); }