I suggest you ...

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.

8 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Walter shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base