none
Slow related entities loading RRS feed

  • Question


  • Hi

    When the main entity is loaded as below it is quiet fast;

    Dim Query = From a In Context.Applicants Where <condititon> Select a.ApplicantID, a.first_name, a.last_name
    


    However when a related entity is included in the query as below it becomes quiet slow;

    Dim Query = From a In Context.Applicants Where <condititon> Select a.ApplicantID, a.first_name, a.last_name, <strong>a.RelatedEntity</strong>
    

    Is there a way to bring related entity but without the speed impact?

    Also is it possible to return only selected fields in the related entity?

    Thanks

    Regards

    Wednesday, July 20, 2011 4:08 AM

Answers

All replies