I have a problem.
I want to paginate
ClassA
ClassA
ClassB
ClassB
ClassC
ClassC
public class ClassA
{
public ICollection<ClassB> ClassBCollection { get; set; }
}
public class ClassB
{
public ICollection<ClassA> ClassACollection { get; set; }
public ICollection<ClassC> ClassCCollection { get; set; }
}
public class ClassC
{
public ICollection<ClassB> ClassBCollection { get; set; }
}
I can resolve with System.Linq.Queryable The solution like this:
var result = from A in DataContext<A>()
.Include(x => x.B)
.Include(x => x.B.C)
.Orderby(x => x.C)
.ThenBy(x => x.B)
.ThenBy(x => x.A)
.Skip(pageNumber * pageSize)
.Take(pageSize);
That's all Folks! :)