Node productNode = new Node(1202);
List<INode> productList = productNode.ChildrenAsList;
int count = productNode.Children.Count;
Response.Write(count);
var enumerable = productNode.ChildrenAsList.Select(t => {
    return new {
        ProductName = t.GetProperty("productName"),
        Pic1 = t.GetProperty("pic1"),
        Pic2 = t.GetProperty("pic2"),
        ProductStyle = t.GetProperty("productStyle")
    };
}).Skip((PageNumber - 1)*PageSize).Take(PageSize);

For example, the database has 100,000 records, productNode.ChildrenAsList is disposable get out all of the 100,000 data, and then return PageSize paging of data, this is still very slow, is actually a fake page, in fact, no use.

Help!