public void PagedListWithNullWhereDoesNotApplyWhereClause() { var testItem = new ClassWithColumnName {NewName = "PagedListWithNullWhere"}; Db.Save(testItem); var result = Db.PagedList<ClassWithColumnName>(1, 1, null); result.Should().Not.Be.Null(); result.Should().Not.Be.Empty(); }
public void GetColumnsUsingPassedObjectTypeInsteadOfUnderlyingObjectType() { var originalItem = new ClassWithColumnName { NewName = "Funk" }; Db.Save(originalItem); var item = new InheritedClassWithColumnName { Id = originalItem.Id, NewName = "Dr", AnotherClass = new ClassWithQueryExplicit { NewName = "asdf" } }; Db.Save((ClassWithColumnName)item); var updatedItem = Db.SingleOrDefault<ClassWithColumnName>(new { originalItem.Id }); updatedItem.Should().Not.Be.Null(); updatedItem.NewName.Should().Equal(item.NewName); }
public void Three_GivenColumnNameAttribute_UsesExplicitColumnQuery() { var item = new ClassWithColumnName { NewName = "Funk" }; Db.Save(item); // Test save command item.NewName = "Dr"; Db.Save(item); // Test update command var getItem = Db.SingleOrDefault<ClassWithColumnName>(new { item.Id }); // Test select single getItem.Should().Not.Be.Null(); getItem.NewName.Should().Equal(item.NewName); var getItems = Db.Query<ClassWithColumnName>(new { NewName = "Dr" }); // Test select multiple getItems.Should().Not.Be.Empty(); getItems.Should().Contain.One(x => x.Id == item.Id); var getPagedItems = Db.PagedList<ClassWithColumnName>(1, 50, "OldName=@Name", null, new { Name = item.NewName }); // Test paged select getPagedItems.Should().Not.Be.Empty(); getPagedItems.Should().Contain.One(x => x.Id == item.Id); }