Preview SQL table content
I often find myself using LINQPad to look at the latest data inserted into database tables. I keep a lot of tabs open with something like
myTable.OrderByDescending(t => t.TableId).Take(10)
I also spend a lot of time flipping through a bunch of tables to find the data I'm interested in.
I think both use cases could be helped if LINQPad could open a temporary tab with the top 10 or 25 rows when clicking/navigating with the keyboard in the tables list in the left pane in LINQPad.
Preferably the results should be sorted descending by the primary key (at least for identity columns).
I'm looking for the experience in Visual Studio where you get a file preview when navigating among files in the solution explorer. You get a tab opened, but that tab is reused for the next preview.