Cache only queries

There are several techniques to help query and find entities in cache.

Finding entities in cache

The EntityManager provides several means of finding entities in its entity cache.  In DevForce-speak, "find" means to perform a search of cache only without attempting to access the server or datastore.  

Finding an entity by its EntityKey

If you know the EntityKey of an entity, you can use the FindEntity method to find the entity in the EntityManager cache.  This is an efficient way both to locate the entity or to prove that the entity is not in cache.

Note that the FindEntity call returns an object, so you must cast the returned object to the entity type expected.

You can also use FindEntity to find an entity with an EntityState of Deleted.  This is the only means of locating an as-yet-unsaved deleted entity.

Finding entities by EntityState

You can also look for entities in cache based on their EntityState.  You can combine EntityStates too, for example to look for all entities which are either Added or Modified.  

FindEntities comes in both generic and non-generic forms, and will return either an IEnumerable or IEnumerable<T>.  If using the non-generic overload you can still cast the results to an IEnumerable<T> in order to build a composable LINQ query.

Finding an object graph

The FindEntityGraph method allows you to search the entity cache for an object graph (aka entity graph) - a list of entities that are navigable from one or more root entities according to a specified graph.  Working with an entity graph is particularly useful when performing a save or import and you wish to work with only the object and its dependent entities.

The FindEntityGraph method takes one or more "root" entities, effectively the starting point of the graph, and one or more EntitySpans , information about the entity relationships to be followed to build the graph.  The FindEntityGraph method also allows you to specify the EntityState(s) wanted.  

This sounds more complicated that it really is, so here's a simple example.  Here we build an entity graph of all orders and order details for a specific employee:

Here's a more complex example.  The EntityManager must be able to "walk" each EntitySpan, in the case above we navigated from Employee -> Order -> OrderDetail.  If a relationship can't be walked, then you must supply another EntitySpan for it. Here we also want to retrieve all Customers for the selected Orders.  To do so we need to include another EntitySpan, one which walks from Employee -> Order -> Customer.

A few more things to note.  

• The "roots" of the graph do not need to be of the same type.
• Deleted entities can be included in the graph.
• The "graph" is just an IList<object>, not a special type.
• Entities not in cache are not lazily loaded when an association is navigated.

Synchronous queries in Silverlight

We've already seen that any query can be given a QueryStrategy to control where it's executed.  When you provide a CacheOnly query strategy, either explicitly on the query, by setting the DefaultQueryStrategy on the EntityManager, or by disconnecting, the EntityManager will run the query against the local entity cache only and not attempt to communicate with the EntityServer.  Since no server communication is performed, you can execute CacheOnly queries synchronously in all environments, including Silverlight applications.

For example, the following will work in any environment:

You can also issue scalar "immediate" execution queries against cache only without using AsScalarAsync .  Here's a First method executed synchronously against cache:

In Silverlight you'll want to take care not to issue these synchronous queries without ensuring that the query will indeed be executed against cache, since an error will be thrown otherwise.