AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Tab sql scratchpad8/7/2023 The icon next to each suggestion indicates the type, and the currently highlighted suggestion gets a popup with more information. You'll see the autocomplete box, as shown below: To list autocomplete suggestions, press Ctrl + Space.įor example, try typing d, then pressing Ctrl + Space. Scratchpad integrates the tern code analysis engine, and uses that to provide autocomplete suggestions and popups containing information on the current symbol. The File menu offers options to save and load JavaScript code snippets, so you can reuse code later if you like. The Scratchpad window looks something like this (on OS X the menu bar is at the top of the screen): This is especially useful in split Console mode: you can use Scratchpad for a persistent, multiline editor, and the Console to interact with the page. Now Scratchpad will be available in the Toolbox, alongside other tools like the Page Inspector and the Web Console. First you need to check "Scratchpad" in the "Default Firefox Developer Tools" section of the Settings page. I've been using it for years, and keep discovering new capabilities (interactive regular expression editing & testing !?).From Firefox 47, you can open Scratchpad inside the Toolbox. I'm afraid this post doesn't adequately convey LINQPad's awesomeness. There are several premium license versions starting at US $59, which add autocompletion & tooltips, code formatting, cross-database querying, etc. There is a free version, which I'm ashamed to admit I used for probably thousands of hours before finally doing the right thing and sending some money Joseph's way. format a column containing JSON with indentation.run the SQL Server query "WITH (NOLOCK)" (in a TransactionScope with IsolationLevel.ReadUncommitted, actually) so it doesn't tie up the table.In this example query, the underlined code uses extensions I wrote to: NET DLLs and NuGet packages and use them in your queries and create/save your own extension methods and classes and use them in your queries: I almost never use SQL Server Management Studio for SQL queries any more. If you do query with LINQ, you can click the results "SQL" tab to see the SQL that was generated: Querying with LINQ is what LINQPad was created for, but you can also query with plain old SQL: I use it a lot for quick code experimentation, and have amassed a collection of tiny utility "program" queries in LINQPad (JSON and XML formatting, removing line feeds and tabs from strings, etc.), but working with databases is LINQPad's main claim to fame.Īs shown in the animation below that I "borrowed" from Jiří Petržilka's blog, if you query a table with foreign keys, LINQPad shows those relationships as navigation links to those entities: If you want to quickly try out some code, instead of creating a console app in Visual Studio, you can just open up LINQPad and and type a line or two. That's because LINQPad isn't just for LINQ and databases - It's for any any C#/F#/VB expression, statement block or program. The screenshot above uses LINQ "query syntax", but of course, you can also use "method syntax" (.Where. Here's a screenshot from an early version of LINQPad (it still pretty much looks the same): NET, and Joseph Albahari introduced LINQPad almost immediately afterward, providing the ability to do database queries using LINQ as an alternative to SQL. NET 3.5 introduced (L)anguage (In)tegrated (Q)uery, one of the killer features of. I use it every day, several times per day. Of all my favorite tools, LINQPad is probably the favorite.
0 Comments
Read More
Leave a Reply. |