1217 results found
-
Is it possible to convert sql statement into Linq statement using LinqPad
I want to convert this statement using linq pad my quey is
SELECT * FROM TblSourceA FULL OUTER JOIN TblSourceB ON TblSourceA.First=TblSourceB.First OR TblSourceA.Last=TblSourceB.Last;
3 votes -
Support SQL Server synonyms in the object explorer
Currently, there is no way to browse the synonyms that are set up for a specific database in the object explorer.
A view of all synonyms for a database would be useful.
4 votes -
Automatically name scripts based on first line comment
Sometimes I'm working on 10-15 scripts at a time, using LINQPad as a true scratch pad for C#. I don't necessarily want to save the scripts, but having a visible name for them - instead of Query N - while they aren't the active tab would be extremely useful.
My idea is to use the first line of the script as this temporary name, as long as the first line is a comment. As an example, see how Sublime Text works.
4 votes -
I suggest add support for Generic List<T> intellisense
When you want place a code that uses Typed Generic List (List<T>), Intellisense does not suggest syntax.. i.e:
List<string> fields = new List<string>(){"One","Two","Three"};
When you type List, must to appears List<T> suggestion.
7 votes -
Generate SQL without Execution
Due to work requirements, I cannot use linqpad in our production environment. Instead I will need to generate a SQL script. This is possible right now, however it requires that you include a SaveChanges call to the context to generate a real script which will also execute the change. It would be nice to generate the script without actually executing the script, this way I can test the SQL script against my test environment without having to reset the data that was changed by executing the script in linqpad.
4 votes -
Add Alt+Enter shortcut to pop up the auto-suggestion drop down (a la Resharper)
When I enter a class name from a namespace that isn't referenced, a little auto-suggestion hint appears. In VS+R# I would hit Alt+Enter to open this menu, and then Enter to accept.
In LinqPad I have to use the mouse to do this.
4 votes -
Detect Oracle VirtualBox as a VM When Checking Licensing
The Licensing conditions say: "three computers ... plus 3 virtual machines running MS VPC, Hyper-V or VMWare". Does anyone else use Oracle's Virtual Box to run VM's in a development environment? Whenever I install LinqPad on a VBox VM, it counts against my PC installs and is not detected as a VM. VM's are for tearing down and setting up quickly and so the "six transfers per year" doesn't cut it either. I actually bought a second license to have to stop deactivating from my non-VM hardware so often.
9 votes -
Dump of enumeration of inherited objects should display actual classes
If I have an enumeration of nodes that can be of type text/html/custom I get the class specific properties in their own columns but there is not indication on the actual class of each line.
When debugging or investigating deep class hierarchies knowing the exact class each line was would be very helpful.
Now one have to determine this through the properties which is not always easy, especially with library code that you have no internal knowledge of.
1 vote -
Ability to turn off the automatic query-finder in My Queries when you switch tabs
When I switch tabs, I don't want the Query-tree to update to find the query I'm currently editing. When you have lots of folders it gets rather irritating after a while.
1 vote -
DB2 Support
This great product offers support for so many database types, but the major one lacking is IBM DB2. You can do this through EF, but you will not be able to see the SQL that your linq queries generate.
15 votes -
Show username in title bar when impersonating (RUNAS)
I often have multiple LINQPad windows open under different credentials, required for operations against remote servers, but I loose track of which is which. I'd be handy for me to show the username in the title bar (perhaps only if impersonating via RUNAS)
1 vote -
easier Date/Time data entry in grid
Our database has an audit field:
[ActionDateUtc] DATETIMEOFFSET NOT NULL CONSTRAINT DEFAULT (SYSDATETIMEOFFSET()),
When I click "Add Row", this field is defaulted blank rather than null, and annoying since the only way to enter a date at this point is to manually key it in.
Save fails due to SQL overflow, and since save happens when you move off the record, it's not easy to copy/paste an existing one.
Ideally it would be fantastic if LINQPad would recognize that the value will be supplied by the DB, failing that a right click menu to enter 'now' or 'utc now' would…
1 vote -
Instance share should include My Extensions
I shared a script with a colleague today. However we realised it would not run because I was using and referencing logic from the My Extensions script.
My idea is that when a script is uploaded to instance share, it should include (or allow me include) logic from the My Extensions script, so that the script is able to be run on another machine without modification
10 votes -
REPL in LINQPad leveraging Roslyn
I'd created an idea for LINQPad to offer a REPL experience already (since I can't use language features like LINQ comprehension syntax or the like from PowerShell scripts), but now that Roslyn CTP is out and csx / C# script is alive, I'm hoping that the effort required would be much lower in LINQPad to offer a REPL. If it only works when Roslyn is installed, then that's fine with me, and it helps bridge the functionality gap for those of us that love LINQPad but want to use it as a REPL so we can keep results/objects/graphs in memory…
73 votes -
show current connection database name for ef db context
When working with curom assembly and connection string coming from config it's not clear which database and server working with as name of the connection will be name of the db contesxt in particular assembly.
It would be really useful to find out which server and database names and also allow different color code base on the name of database or server to distinguish between dev/test/prod.
1 vote -
Stop linqpad from querying __MigrationHistory on each call
EF queries the __MigrationHistory each time the DbContext is opened to ensure the DB context is in sync with the DB. This can be very expensive. Can LinqPad provide an option to skip this check by doing Database.SetInitializer<UserQuery>(null)?
UserQuery seems to be the class that gets derived from the user created DbContext.
4 votes -
Load a webpage into iframe in results window
I would like to use a function like Util.LoadPage(string url int width, int height) to load a webpage into an iframe in the result window.
Currently I'm using File.WriteAllText(fileName, contents, Encoding.Default); and Util.RawHtml to push the iframes into the result window, but for some reason the iframes opens up internet explorer in most cases.
8 votes -
run current command
Thanks for AMAZING productivity tool. I would like a feature to run only the command at cursor (not all commands on page). Suggested invocation - right-click context menu option and/or [Alt/Ctrl] + F5.
5 votes -
add a dark theme
i find dark themed environments a lot more comfortable to work in. That's why almost all IDE's have them as an option.
4 votes -
Clicking "add connection" needs a SQL Server option
Click "add connection" there are 3 options "linq to sql", "WCF..." and "MS Datamarket...". None of these allow me to connect to SQL Server. Nothing in "view more drivers" looks like SQL Server either. My friend got it to work after a lot of time & effort, but doesn't remember how he did it. SQL Server is very popular. It should be easy to connect to it.
1 vote
- Don't see your idea?