NQuery - Querying object graphs with "SQL" like strings
I discovered this awesome library called NQuery on CodePlex. It allows you to query an object graph using a SQL like syntax.
This creates some interesting possibilities for potentially writing the same queries which can work against the database and an object graph when caching is employed.
Check it out here. There is also a nice demo application which comes with it so you can test it's capabilities.