This is a consequence of query inversion. (From wiki: "Query inversion is the process of retrieving those non-targeted objects that are nonetheless necessary for correct completion of a query")

 

The reason for that is is so that the query can be applied against a pool of data that combines unpersisted local data with data that exists in the datasource.

 

If you want to avoid this behavior, you should query the DataSourceOnly. (setting QueryInversionMode to Off will also set the QueryStrategy to DataSource only)

 

You can find more info about QueryInversion in our DevForce Resource Center.

 

Silvio.

I have a query like this:

What I have noticed is that because of the last where criteria "p.p_deviceItem.p_visible > 0" , the Entity items for "p.p_deviceItem" are loaded too from the database and put into the Entity Cash on the client.
It looks like this last where criteria is performed in the Entity Model but not in the Database Engine that would of course be faster and eliminate loading the p_deviceItem Entities from the database.
Why is this such? Can this be avoided?