persistent query results and refine locally
The idea is enable the following:
- let me run a query, it brings down the results
- I call .ToList() on the result in order to run client side queries on the results without hitting the db.
- I add some more statements that query the results even further, but hitting F5 will *not* go back query the db, but rather the results are presisted between F5 executions.
in other words I get a dataset once locallly and can then slice and dice and query it to my liking until I get the query/data pivoting I need.
This would allow me to go against a "live" db without worring that I'm creating too much load due to constant F5's.
This is now supported via the Cache method. Go to Help | What’s New and search for ‘caching’ for an example