I suggest you ...

Always auto-execute query on column sorting.

If you disable query auto-execution as Beth Massi suggests at http://blogs.msdn.com/b/bethmassi/archive/2012/05/29/lightswitch-tips-amp-tricks-on-query-performance.aspx
you lose the convenience of sorting grid columns. If you wish to sort on some column you have to first click on its head, and then refresh the screen. As far as I know, there is no such an event like grid_sort() exposed where you could programmatically refresh the screen.

If “Auto Execute Query” property is disabled and you click the sortable column head, refresh automatically i.e. “auto-execute” the query!

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Atanas BogdanovAtanas Bogdanov shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    closed  ·  Visual Studio UV Site AdminAdminVisual Studio UV Site Admin (Admin, Microsoft) responded  · 

    Thank you for your suggestion! While we aim to respond to every suggestion, we are closing older ones that don’t have enough votes so newer ones from you can move to the top. If this suggestion is still important to you, feel free to open it again.

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Atanas BogdanovAtanas Bogdanov commented  ·   ·  Flag as inappropriate

        Same for other “supports” which obviously rely on auto-execution feature: “Support paging” and “Support search”:
        On clicking “Page navigation” control -> go to the requested page.
        On “Search” clicked -> show filtered result.

      Feedback and Knowledge Base