1190 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 -
Add 'Dump' to 'View in grid' menu and to IEnumerable elements
When viewing some complex data structures, it would be very useful to be able to re-dump particular parts of the structure. I.e., either by right clicking a cell or by using the > arrow that brings up the menu with 'View in grid', I'd like to be able to dump that particular element.
3 votes -
Add ablitity to refresh schema for individual table, not the entire connection
Currently I can right-click on connection and pick Refresh to refresh schemas for all tables. I'd like to be able to do the same with individual table as with Azure driver refreshing schemas for all tables takes a very long time.
3 votes -
A tutorial for IL
I have recently started looking at the generated Intermediate Language and it makes a lot of stuff clear on why C#(in my case) behaves the way it does.
It would be nice to have a tutorial about IL and how to interpret it along with some examples explaining the behaviour of certain operations.3 votes -
Option Strict On
Let the change to Option Strict On for scripts that use VB.NET to be more accessible. Instead of going to the preferences menu, an option like the Turn Optimizations ON/OFF would allow fast switch for testing purposes
3 votes -
Customizable hotkeys
Ability to change hotkeys.
3 votes -
Powershell script as output
Add possibilty to generate powershell code as output from linqpad script.
3 votes -
Open New Query Tab When Pressing Middle Mouse Button on the Tabs Bar
Open New Query Tab When Pressing Middle Mouse Button on the Tabs Bar Like Firefox or Chrome.
3 votes -
Costum fast queries
It is great that we can right click a table and say Take(100) or where whithout having to type. But it would even be grander if we could customize these options.
Example, we use a lot orderbydesending(x => x.inserdate) on different kind of tables over different databases. How easy would it be if we could use have this query 2 clicks away ?!3 votes -
Change the application icon to the old one (4.x) or change to a better one
I mean no offense, but the new icon (LinqPad 5.0) looks like a polygon made in 2 minutes using CorelDraw. The old one (4.x) is much better, more polished and represented perfectly the program and its purpose.
3 votes -
Database specific My Extensions
Add "My Extensions" that are used in place of the default for a given database, or one that does not interact with the normal "My Extensions", but can be used to extend the database.
3 votes -
Autocomplete lambda expression on adding event handlers
myForm.Activated += // then, suggestion like "(sender, e) =>" is shown
3 votes -
when I call " Console.writeline(Obj); " with overridden ToString in my Obj then LinqPad does not show the simple String Output but some kind
when I call " Console.writeline(Obj); " with an overridden ToString in my Obj then LinqPad does not show the simple String Output but some kind of formatted object structure of Obj. I did not find a switch for that behaviour anwhere. I can work around with using Debug.WriteLine instead of Console, but a simple switch in the UI or Preferences would be nicer.
3 votes -
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…3 votes -
Ability to sort files in "My Queries" tab
Just a minor suggestion. I'll like to be able to sort files in the "My Queries" tab - by date modified, by date created, by name etc. I experience a little frustration having to remember the name of the last file I worked on.
3 votes -
Automatically Select "SQL Azure" if connection string in clipboard's "Server" property ends with ".database.windows.net,1443"
Given a SQL Connection String is in the clipboard:
Server=tcp:my-sql-azure-sql-server-name.database.windows.net,1433;Database=my-initial-catalog;User ID=user@my-sql-azure-sql-server-name;Password=ALRh2AxHV6f8;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;
When the "Server" property of the connection string or equivalent ends with ".database.windows.net,1433" then the assumption that this database server is a SQL Azure connection string and automatically select the "SQL Azure" radio button at the top of the "LINQPad Connection" dialog box.
3 votes -
Persist size and position of undocked results window
When you click 'undock results to second monitor' the resulting window's size and position should be stored on close so that it opens in the same position next time (rather than being maximised, which is never what I want).
Part of the problem is that the child window doesn't respond to WindowsKey + arrow to snap to one half or another even though dragging the titlebar does work (to the left hand side).
3 votes -
Support foreign key columns ending with "Fk" instead of "ID"
Currently entity navigation is optimized for table columns ending with the suffix "ID", for example a CustomerID will get a navigable "Customer" field created.
In a database where the pattern is like CustomerFk, the navigable field would be named CustomerFkEntity, which is painful to write each time in queries.
Please allow a more permissive foreign key naming detection or allow it to be configurable.
3 votes -
tab focus
After closing a tab the next tab to get focus should be in order of most recently used.
3 votes -
AutoComplete object type filtering (Similar to ReSharper)
Like many others, I've grown to love certain features of ReSharper. One such feature is the ability to filter the AutoCompletion list by object type using keyboard shortcuts or by clicking on the icon of the object type (such as namespace, class, interface, property, field, etc.). I think that this would be a really nice addition to LINQPad.
3 votes
- Don't see your idea?