How to paginate data from child object in EF?

Question

I have a problem.

I want to paginate

ClassA

.

ClassA

has a list of elements of type

ClassB

, and

ClassB

has a list of element of type

ClassC

.

How can I paginate data by the number of elements from
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; }

}

Recommended for you: Get network issues from WhatsUp Gold. Not end users.

Answer 1

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! :)

How to paginate data from child object in EF?

Sign up