I am trying to load a list with thousands of entities with LINQ:
|var customers = scope.Extent<Customer>(); // about 80000 entries
The problem is that each Customer object references to other tables like CustomerState and Country. Now I try to bind this list to a Grid (no Telerik Grid) which contains these joined properties.
OpenAccess seems to load each entry with it's joins. So the app comes to a complete halt.
What can I do? Could views solve the problem? Where is this documented?