public void Should_ReturnDataSortedByUserName_When_AllUsersIsReturned()
{
// Arrange
var orderMember = "UserName";
// Act
var data = _sut.QueryToTableValuedFunction(DbConfig.DbObjectNames.GetAllUsersFunction)
.OrderBy(ExpressionBuilders.MemberAccess(orderMember))
.ToArray();
// Assert
Assert.AreEqual(data.Count(), 3);
}
public void Should_ReturnItemsWithCorrectOrdering_When_CompositeOrderingIsApplied()
{
// Arrange
var expectedUniqIdsOrder = new[] { 40, 10, 30, 20 };
// Act
var data = _sut.QueryToTable(DbConfig.DbObjectNames.ReportsTable)
.OrderByDescending(ExpressionBuilders.MemberAccess("Id"))
.ThenBy(ExpressionBuilders.MemberAccess("FileName"))
.ThenByDescending(ExpressionBuilders.MemberAccess("CreatedBy"))
.ToArray();
// Assert
for (int i = 0; i < expectedUniqIdsOrder.Length; i++)
{
Assert.IsTrue((int)data[i]["UniqueId"] == expectedUniqIdsOrder[i]);
}
}