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