1191 results found
-
Add support for Failover Partner when creating a SQL connection
We have 2 SQL servers set up with mirroring. Some databases are live on one and passive on the other and vice versa. It would be handy if I could put Failover Partner in the connection string to save me having to have 2 different connections.
4 votes -
Allow WCF Data Services libraries to be configurable
Since LINQPad is an OData client, it be great if we could configure it to use the latests WCF Data Services libraries, which are now released out of band from the Framework. e.g. http://www.microsoft.com/en-us/download/details.aspx?id=29306 is a release that supports Any/All queries, but LINQPad will throw a NotSupported exception when using the exact syntax explained here: http://blogs.msdn.com/b/astoriateam/archive/2011/05/31/any-all-support-in-wcf-data-services.aspx
2 votes -
Provide a link to the line causing an exception from the information bar
The yellow bar at the top shows the current exception but if you have a very long linqpad script you need to scroll down to see where the error happened. It would be nice to be able to click the yellow bar to jump down to the exception.
1 vote -
Add T4 to the list of languages
Having an access to data or implementing your own data provider, will make LinqPad an awesome tool for AutoCode Generation and Testing.
I wrote my own MsSqlMetaData (Just and EF provider for system views, it's on NuGet) provider and currently generating a lot of code, but writing c# programs to generate code is not as easy as using text templates.28 votes -
Generate INSERTs from grid
Just another export option or another mode/button near Output, Grid 1, λ, SQL, IL
Would be really nice to have this possibility when I would need to copy some records from one DB to another via Remote Desktop connection20 votes -
Update Microsoft.WindowsAzure.* assembly references to latest versions
Obviously, features new to 1.7 (and later) will not be available as LinqPad seems to reference the 1.1 version. Also, I've been having this issue:
Assembly 'MyAssembly, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' uses 'Microsoft.WindowsAzure.StorageClient, Version=1.7.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' which has a higher version than referenced assembly 'Microsoft.WindowsAzure.StorageClient, Version=1.1.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
0 votes -
Cross database platform LINQ support
LINQPad should be able to join results from two different database platforms in one Query.
In our situation we would like to use it to join data stored in RavenDB with data stored in SQL Server. But I can imagine that there are many real life environments where one would like to join data in one database platform with data in another database platform
6 votes -
4 votes
-
Support Oracle SQL tab!
Support Oracle SQL tab!
Debug the sql statement generated by EF with oracle,please!3 votes -
Allow the File, Edit, Query, and Help menus to drop down on mouse hover.
It would be nice if hovering over the menu titles caused the menus to dropdown and show the items, rather than requiring a click action on the menu titles.
1 vote -
Provide language-dependent query snippets for items in the schema tree (in the context menu)
Currently, all the snippets provided as native LINQ statements and method calls only, irregardless of the nature of the connection/provider. It would be useful to have these snippets in all languages supported by LINPad and (more importantly) applicable to the specific connection/provider, like for instance ESQL or plain SQL. The snippets could be organized in sub-menus by language.
2 votes -
Support EF derived entity types in the schema tree
If one has derived entity types defined in the model and doesn’t use MEST (default scenario), the derived entities are not shown in the schema tree, since only entity sets defined in the model are currently shown. Per default it means only base entity types. It makes model exploration capability very limited. Consider a model where all the entities derive from a single base type MyObject (arguable but viable design). Then you end up with only one “table” entry MyObjects in the schema tree with few to none properties defined. All the hundreds of “real” types with all their valuable…
9 votes -
Convert URI to linq
I have a odata URI. I need a translation of it in Linq using linqpad. Is it possible?
1 vote -
Compact (and name) the amount of SQL Parameters
The amount of duplicate SQL Parameters are too damn high :-)
eventhough i in C# declare the inputs as variables, the SQL parameters are duplicated pr use of the paramenter.
eg:
var DS = 127;
var genart = "00402";
var critno = 100;becomes :
-- Region Parameters
DECLARE @p0 Int SET @p0 = 100
DECLARE @p1 VarChar(1000) SET @p1 = '00402'
DECLARE @p2 NVarChar(1000) SET @p2 = '-1'
DECLARE @p3 Int SET @p3 = 100
DECLARE @p4 Int SET @p4 = 2
DECLARE @p5 VarChar(1000) SET @p5 = '00402'
DECLARE @p6 NVarChar(1000) SET @p6 = '-1'
DECLARE @p7 Int…4 votes -
Short Date
I would find it helpful if I could control the date formatting. For me and my companies data, I'm usually only concerned with the date not the time. The time tends to fill up the columns. Can we get some way to control how dates are outputted?
1 vote -
1 vote
-
provide the ability to query multiple schemas with the IQ driver for oracle.
An Oracle user may have access to multiple schemas with table definitions. It would be nice to specify the schema in the query.
E.G. I have a user that can see two schemas ,users and customers. Currently I have to specify the schema I want to use when setting up the connection. So, I can only query one schema per session. It would be great if I could do something like the following:
var customers = from c in customers.sometable
select c;
var users = from u in users.sometable
select u;
...
in a single session65 votes -
LinqPad as a user control to embed in my apps
Reporting made easy...just write linq scripts and ship them with your app with the linqpad user control embedded in the app too. :)
I would prefer it in WPF but would settle for winforms.
110 votes -
Support for multiple databases (EF/L2S) on different servers
I would like to be able to query multiple databases, that are on different servers. Possible use would be "server.database.table" or something like that.
13 votes -
1 vote
- Don't see your idea?