1215 results found
-
Drag-n-drop CSVs into an instant table
Drag-n-drop a CSV file to the LINQPad window to silently create an IQueryable object populated with its values and insert a code reference at the cursor point where the drop operation completes.
1 vote -
add a way to get iwin32Window from linqpad
Dim wnd As New NativeWindow()
wnd.AssignHandle(Process.GetProcessById (Util.HostProcessID).MainWindowHandle)'Add the above code or the c# version of it to a Util function that lets us pop up dialogs that show above the linqpadwindow.
'_____
Dim browser = New FolderBrowserDialog With {.ShowNewFolderButton = False, .SelectedPath = pth}
If browser.ShowDialog(wnd) = DialogResult.OK Then
pth = browser.SelectedPath
End If3 votes -
Allow LinqPad Query to access internal members of referenced libraries
It would be great if LinqPad query can access internal members of referenced libraries without changing the referenced libraries to add
InternalsVisibleTo
attribute. Instead we could use the reverse attributeIgnoresAccessChecksToAttribute
in the query to allow it to access internal members of any specified libraries. You can find detailed information on how this can be done here: https://github.com/aelij/IgnoresAccessChecksToGenerator and https://github.com/filipw/Strathweb.Samples.CSharp.NoVisibilityChecks3 votes -
1 vote
-
Expose Program.IsAutomated via Util class
Currently we resort to reflection on the LinqPad internal classes to extract some very useful properties. One of these features is IsAutomated property of the internal static Program class, which is similar to #if CMD but is more practical because you can pass it around. Besides it's impossible to determine if a script it running under lprun inside MyExtensions using the said #if CMD directive. Because it is a compilation directive.
1 vote -
Provide a means to change the target framework (e.g., the .NET Micro Framework, etc.)
I don't know if this is feasible, but it would make LINQPad orders of magnitude more useful to those of us working in multiple target platforms.
49 votes -
Cross-server and cross-domain queries
It is time to move to the next level: cross-server or cross-domain queries, for a truly great orchestration experience.
I have experimented with this and it's working nicely:
dynamic odata = Activator.CreateInstance(Type.GetType("LINQPad.User.DemoService, odata", true), new Uri("https://services.odata.org/V3/OData/OData.svc/"));
((object)odata.Persons).Dump();
dynamic a = Activator.CreateInstance(Type.GetType("LINQPad.User.TypedDataContext, a", true));
((object)a.Persons).Dump();
dynamic db = Activator.CreateInstance(Type.GetType("LINQPad.User.TypedDataContext, db", true));
((object)db.Products).Dump();I'm specifically referring to this line in the FAQ (https://www.linqpad.net/FAQ.aspx):
"The databases that you query must reside on the same server."That's a major limitation.
Possible solutions:
1. Unique data context class names in the LINQPad.User namespace.
2.extern alias
functionality?
3. Uniquely nest all classes…1 vote -
Add codepage support to Util.Cmd
Basically you need to change the ProcessStartInfo.StandardOutputEncoding with the supplied codepage, or get the default from registry. Localized versions of Windows will print gibberish with basic operations like Util.Cmd("ping localhost")
1 vote -
Add Random newid() support to TypedDataContext
Super easy, add this method to your Program script:
[System.Data.Linq.Mapping.Function(IsComposable=true)]
public Guid NewId() => Guid.NewGuid();Then use like this:
Users.OrderBy(o => NewId())
This will translate to the usual sql statement for the server-side execution:
select * from Users order by newid()
Which is shuffling on the server side.
The C# implementation is never used (Guid.NewGuid()) but is useful nonetheless if someone calls it from the application-side. You can replace it with throw new NotImplementedException() and it will still work just fine.
Would be great if it was embedded into the TypedDataContext (or elsewhere) within LinqPad.
Based on Marc's answer here: …
1 vote -
Name User License for Linqpad
Name User License so I log on for use software with same attual restriction (6 user for license activated). So I can use the software without active/deactive but limit of connection for user
1 vote -
"Show all nestings levels" works only for the first items!
"Show all nestings levels" works only for the first items! Not for all. Please fix!
3 votes -
BUG: automatic intellisense occuring on single letters
When typing something like
.Where(x => ....)
pressing space after the x fills in the intellisense menu choice which pops up automatically.4 votes -
Query result shown as rich text when run from stored file - default setting = data grids
My default for an SQL-result is "data grids". But when running a script from a saved SQL-file, the result is shown as rich text (html).
Please apply the default in this situation as well. Thx
1 vote -
Add Connections using Data Context from a NuGet Package
It would be great to be able to package up custom DbContext assemblies and app.configs (e.g. dev, uat, prod) in a NuGet package then reference the package from the "Add Connection" dialog.
10 votes -
NuGetPackageFolder
<NuGetPackageFolder>C:\packages</NuGetPackageFolder>
is not effective when it is placed in (RoamingUserOptions.xml nor UserOptions.xml) the same path as LINQPad.exe6 votes -
Bug: IOException on first run with 2 piped lprun's because of building shared Extensions
Setup:
a.linq:
"a".Dump();b.linq:
"b".Dump();Delete all *.dll, *.pdb in plugins folder (for example, LINQPad Plugins\Framework 4.6), leave the MyExtensions.FW46.linq file for compilation;
Then run: lprun a.linq | lprun b.linq
This is the output:
c:\users\user\Documents\LINQPad Queries>lprun a.linq | lprun b.linq
IOException: The process cannot access the file 'C:\Users\User\Documents\LINQPad Plugins\Framework 4.6\MyExtensions.FW46.dll' because it is being used by another process.
at LINQPad.TaskExtensions.GetResult[T](Task`1 t)
at LINQPad.MyExtensionsManager.CheckForStaleExtensions()
at LINQPad.CmdLineAppHost.Run()
at LINQPad.Cmd.LPCmd.Run(String[] args)b
1 vote -
Automatic proxy detection not working
Hello,
First of all: LINQPad is a GREAT productivity tool and in our company we have many users, using it on a daily base. I love the new feature to great simple chart in the Dump output!Here is a little issue. The automatic proxy detection of LINQPad is not working properly. In our environment with a NTLM based authenticating proxy and a proxy.pac file in use it is not working.
This is most likely due to not setting the HttpWebRequest.Proxy.Credentials property before sending a request.Here is a sample C# code where it works and is explained step-by-step:
//…
1 vote -
Edit and debug Cake files
Would've been really cool if you could edit and debug Cake build scripts in LINQPad.
23 votes -
seek White Listing status with Symantec EndPoint Protection
The latest SEP virus definition update has flagged LINQPad.exe as a virus and Quarantined it.
1 vote -
Include the current query name (if saved) to the title bar
The time tracking software I use, TimeSprite, uses the window title to track time and assign to tasks. LINQPad always just shows as "LINQPAD" - but when a query is saved, including the file name in the title bar (like Word, Excel, etc. does) will let users identify the current query, and will facilitate time-tracking apps such as TimeSprite to assign queries to projects.
16 votes
- Don't see your idea?