1205 results found
-
Have a short tutorial on how to query a Sql Server database
I downloaded LinqPad. Opened it and added a new db connection, but how do I actually query? Please give some example code.
For example, I have a table called 'Login'.
i wrote: 'from l in Login select l' but I get errors when executing this.How do I actually query against my database? Do you have some sample code.
Thanks
4 votes -
Add option to disable completely Instant Share
Why is this option not disabled yet? I am being asked to not use LinqPad any longer in my day to day workflow because someone accidentally shared something to Instant Share.
We need to be able to:
a) disable the menu item so that it cannot be accidentally clicked (or even seen)
b) disable the hot key combo so that it cannot be accidentally hit
c) manage the scripts that have been uploaded on our behalf so that we can delete any sensitive scripts.Scripts should not be automatically made publicly accessible without warning and should certainly not be left…
4 votes -
Support mapping [String].Split() to SQL 2016's STRING_SPLIT
SQL 2016 supports built-in function STRING_SPLIT().
This function corresponds to .net [String].Split(char).
Please enable mapping from C# to SQL when calling .Split() on a string.4 votes -
Add abiltiy to copy minimum working example (MWE)
It would be nice to have the option of copying a 'Minimum Working Example' to the clipboard. This would make it easier to e.g. post a question on StackOverflow.
It should include all namespaces and a full class declaration containing a static Main-Method. Also see here: https://stackoverflow.com/help/mcve
4 votes -
Option to enable server garbage collection
Would be useful when experimenting with F# Hopac.
4 votes -
Show Color and Image when Dump()
I like Xamarin Workbook,
but i prefer Linqpad more, please integrate it with SkiaSharp, when Dump, to have an option to see Colors and Image4 votes -
Distinguish NULL values from strings that might be spelled, "null" or "NULL"
It is currently impossible to distinguish between a NULL value and a string that happens to be spelled, "null" because LinqPAD displays "null" (lowercase) for both of them. SSMS displays NULL (uppercase) for NULL values, and to differentiate between NULL values and a string spelled, "NULL", SSMS highlights actual NULL values with a special background color (a soft yellow). LinqPAD should do the same thing, or something similar, to make it more obvious if the value is NULL or a string that just happens to be spelled "NULL".
4 votes -
Add quick filter box
Add a quick filter box at the top of the My Queries and Samples list to easily filter by name - without having to go into "Go to...". Rename "Go to..." to "Advanced Filter"
4 votes -
Please don't install a new update when I open LinqPad
I regularly run LinqPad on clients' PC's in order to troubleshoot a database problem, rather than installing SQL Management. I don't like having an automatic update downloaded in the background onto their machine especially knowing that I will never use it anyway.
4 votes -
Please support vi emulator commands with inner/outer/tag modifiers
Only d is supported currently. ci( ca( vi( va( etc. Also, cit vit etc? Thanks much!
4 votes -
Exclude replication objects from database object tree
It would be great if replication objects and MS shipped objects could be excluded from the database object tree. I don't have the "Include System Views and SPs" option checked on the connection.
Whether it's a new option or controlled by the same include system option, it would be nice to be able to exclude objects that are ismsshipped and replication objects (that don't have ismsshipped = 1 but do start with 'sp_MS') like the examples below.
-- MSreplicationobjects
-- MSreplicationsubscriptions
-- MSsubscriptionagents
select
s.name,
t.*
from sys.tables as t
join sys.schemas as…4 votes -
Option to have Output autoscroll
Most of the time people dump one chunk of data but when modifying "live" data I need to track where a task is upto in case i need to pause/stop and resume at a later time.
To do this I output myself (Console.Writeline) progress stats and the current ID im working on in my loop.
I can't see an option to have the Output autoscroll on Writelines!
4 votes -
Command to insert a new GUID into query text
Add editor command to insert a new GUID into the query text.
The current workaround requires opening another tab and running Guid.NewGuid() command there, then copy-pasting back to original query.4 votes -
Auto-update at time of install
When installing LINQPad (6), it would be good for the installer to, either during or post, run a hidden instance that preforms the auto-update.
For those of us who package it in SCCM, this would be of significant benefit.
4 votes -
Support any file type in the editor tabs and query explorer.
For example JSON/XML/CSV/Excel data used for testing out a snippet or library.
Just for the overall convenience... and when you get back 6 months later and look for the input data!4 votes -
Allow Database connection panel to be closed
Most of my LINQPad scripts do not use a database connection... so I'd like to be able to set a preference to close the connection panel (top left).
4 votes -
Output LINQ/C# text as a comment into the generated SQL
SQL Server keeps track of all queries, including the text. Sometimes queries don't work as expected (timeout, errors, etc.) but sometimes it's also very useful to have a record of everything that is done as a log. I see the generated SQL. I'd like to know the C# that was entered into the query window. As an option, could you add this as a comment?
4 votes -
Add option to format document on save
Have a setting to format document on save.
In visual studio I use codemaid and whenever I save files it formats them.
Would be nice as one of those menu elements with a checkmark beside them.4 votes -
Please add a mode to the Output panel to render Markdown that is emitted from code.
I like to format error messages and other output with Markdown to make it easier to create reports from code (I typically use LinqPad to free-hand test code and apply weird edge cases or explorer difficult bugs). Seein my output properly formatted will help me and my clients visual what their code is doing. And adding support to render PlantUML would also rock.
4 votes -
Laundy list of desired features:
Laundry list of desired features:
- Export Query to Dotnet SDK Project.
- Import / Export CSX (C# Script) Files
- Incorporate the C# Interactive Runtime and add immediate window, Like Visual Studio. Would be a huge help during debugging.
- Add Unit Test Management with support for MSTest, nUnit and xUnit projects.
- Seriously consider adding a Report Builder. LinqPad is already 75% of the way to replacing MS Access. This could put the nail in the coffin for MS Access.
4 votes
- Don't see your idea?