285 results found
-
Cross Database Linq support
LinqPad should be able to do Cross-Database statements.
The user could enable this, by manually adding the tables from each database which should be used in the statement...
Currently this option is enabled by making a DataContext and use that. however, it would be much faster if Linqpad supported this natively...
227 votes -
Support Oracle
This replaces the more general suggestion "Support Oracle / MySQLl / SQLite". Vote here if you need Oracle support.
217 votesOracle support is now complete – let me know how you get on. Go to Add Connecton | View More Drivers and download the IQ driver. You’ll need LINQPad v2.35/4.35 or later. This driver is free of charge.
-
Open Table for Edit as in SQL Server Mgmt Studio
SQL Server Mgmt Studio allows one to open tables for editing data. In order for LINQPad to be able to replace SQL Server Mgmt Studio, as the LINQPad challenge suggests, the editing data directly feature is needed
207 votesThis is now available to LINQPad Premium users in latest beta: www.linqpad.net/beta.aspx. Let me know what you think.
-
"My Extensions"
There should be a way to write and maintain a set of extension methods that would be made available to all query windows in LINQPad.
146 votesThis is now complete. Go to “My Queries” and click the “My Extensions” query.
-
Support Oracle / MySql / SqLite Databases
What are people's thoughts on this? Which is more important: Oracle, MySql or SqLite? Should the support be through custom Entity Framework-driven DataContexts or via automatic DataContexts?
144 votesClick Add Connection and ‘View More Drivers’
-
Include other scripts
I'd like to factor out some code into a script I include because I use this code across scripts. I don't want to have to compiled to an assembly and reference it because then I can't "script" it anymore.
Please include an "include" syntax or GUI setup (which will then obviously manifest itself in the .linq XML prelude.)
141 votesThis is now available in LINQPad 6:
https://www.linqpad.net/LINQPad6.aspx -
Add ability to target .NET Core
.NET Core is gaining adoption, and I find myself needing to experiment on .NET Core more and more, especially since .NET Core has it's own surface area. It be great to be able to do this in LINQPad.
I don't need LINQPad to run Mac/Linux, just the Windows version to be able to target .NET Core.
129 votesA public beta is now available: https://www.linqpad.net/LINQPad6.aspx
-
Allow to set query transaction isolation level
Most of our queries' transaction isolation level is ReadUncommitted. This is very important on our production db to minimize the impact.
I find myself surrounding my queries with TransactionScope all the time.
In addition, some of the queries requries Snapshot isolation's, etc.
It would be very helpful to allow to set the isolation level in the advanced query properties or something similar.
Thanks.129 votesThis feature is available in LINQPad 8.
-
nuget integration
Nuget integration into linqpad for automatically adding dll in a folder and embed them in a query
122 votesNuGet integration is now available for LINQPad Premium users in latest beta: www.linqpad.net/beta.aspx
-
Add support for f# type providers
F# 3.0 type providers seem like they would fit in quite well with the LINQPad-as-data-explorer mission.
119 votesThis feature has always worked AFAIK.
-
Add scriptcs support
It would be great if LinqPad would support scriptcs or Roslyn since it already has NuGet support. Another option would be to export the .linq project as scriptcs project.
117 votesLINQPad 9 supports .csx files and the #r directive.
-
Add basic authentication support for custom nuget sources
When you have a self hosted feed or a private feed on myget, its typically secured by basic authentication. Would be great if you could add support for this when adding new feeds in the Nuget Settings dialog. Current behavior is that it throws an unauthorized error from Nuget.Core
116 votesNow available in latest LINQPad 5 release: http://www.linqpad.net/download.aspx#beta5
-
Allow conversion of SQL to Linq (where possible)
It would be great if I could paste in an existing SQL query and convert it to LINQ. This capability exists in other tools, but I would prefer to use LINQPad for everything.
116 votesLINQPad 9.5.1 includes a new tool to perform an AI-powered SQL to LINQ conversion. This is designed to perform a deep conversion, following best practices, and avoiding transliteration. Please provide feedback!
-
Provide a format statement option context menu item
This function would clean up the statement by providing tabs where necessary (align and indent).
115 votesThis was completed in LINQPad 5
-
Create an IRender plugin interface and create some additional default rendering engines for content
LINQPad is slow when returning large result sets due to it creating and having to render a lot of HTML. It would be nice if there were an option to use a ListView, DataGrid, or any other type of interface that can accept and render data via an IRender interface. It would be great if this were created so that 3rd parties could write Plugins. Additionally, a ComboBox that could be selected would update the results in a different view.
Of course, it would be difficult to render sub-data (Orders->Products) like is done now, but I think that is an…
98 votesThis is now complete. Go to Help | What’s New for info on how it works.
-
97 votes
PostgreSQL support is now built in to LINQPad 6 (and available in LINQPad 5 via third-party drivers.)
-
Add Active Directory Universal Authentication support for Azure SQL database
SSMS already supported it. https://azure.microsoft.com/en-us/documentation/articles/sql-database-ssms-mfa-authentication/#connecting-by-using-universal-authentication-with-ssms
We are migrating password authentication to Azure AD authentication for Azure SQL databases. And the Azure AD is not connected to the AD in corpnet. So we can't use Azure AD Integrated Authentication to access DB on Azure. Also the Azure AD requires certificate authentication, so we can't use Azure AD Password Authentication either. Active Directory Universal Authentication is the only choice.
95 votes -
ALT + Arrow Up/Down should move current line/selected lines accordingly
As a developer I often have to rearrange code lines. Therefore it would be a useful feature to be able to move the current line / currently selected lines up/down, the same way as it is possible in Visual Studio or Notepad++.
90 votesIf you're unhappy with the default shortcut for this (Shift+Ctrl+Alt+up/down), you can customize the shortcut keys in LINQPad 9.
-
Add Entity Framework support for Code First
The Entity Framework support currently requires the different xml files; EF will support Code First (currently in features CTP 3) which is all code, no xml files. It would be great to have LINQPad allow for EF Contexts using Code First.
75 votesLINQPad now supports both standard and code-first models.
-
Support writing unit tests
Allow us to create unit tests using NUnit or similar (either needs a new option in the Language dropdown or a one-liner you could put in your Main function to kick off a test runner). Running it would run all the Unit Test methods it finds. Taking this one step further, you could even support an auto-test mode, where every time you saved, if it compiles it runs all the unit tests it finds, making it the ideal for doing code katas in
69 votesLINQPad now has special xunit support as of 6.9.12, via new options on the Query menu. ‘Add XUnit Test Support’ adds the necessary dependencies + creates a customizable xunit runner. “Run Tests” (shortcut Alt+Shift+R) invokes the RunTests() method.
- Don't see your idea?