This is my table structure and I have set up TargetPerEntity for all the classes.

Event |---AudioEvent |---VideoEvent |---VideoPlayedEvent |---RecordEvent |---RecordPlayedEvent etc

DataAccessAdapter adapter = new DataAccessAdapter();
EntityCollection events = new EntityCollection(new EventEntityFactory());
adapter.FetchEntityCollection(events, null);

The fetch is polymorphic and I get the right derived objects in my result. Which is good in most cases.

Is there any way to fetch only the items of my root object and not my derived objects when using the Entity collection? I want to avoid the overhead associted with fetching the derived table data.

Thanks, KK

• Use a DynamicList to fetch only the data in the Events table.
• You may project the resultSet into an EntityCollection.