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