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
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Walter shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base