1205 results found
-
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
-
Allow users to disable highlighted text execution
If I attempt to run a query with anything highlighted only the highlighted text is executed. This is a really nice feature for some scenarios but I'd really like the ability to turn it off.
When I'm building longer code queries i almost always have code highlighted inadvertently so I am constantly accidentally executing a few lines of code. This is usually just annoying but it has a huge potential to be dangerous as well as it lets me accidentally bypass my other conditions when doing data operations.
9 votes -
4 votes
-
1 vote
-
New Cache() extension - let it be parameters sensitive?
The new Cache() extension is absolutely great feature. One caveat though is that it is not parameters sensitive and it might be misleading in some cases.
A very simplified example:
int userID = 7;
Users.Where(u => u.UserID == userID).Cache().FirstOrDefault().Dump();When I run it - I get the expected user entity.
Now, if I change userID to 8, and I forgot I used Cache(), I will still get the user with ID 7, and I might execute a wrong logic.
To handle that - I use Cache(string) method with key which is combined by the relevant parameters for that query.
Anyway…
1 vote -
Manual DB Connections
Allow connections to be marked as manual. they exist but will not connect unless prompted to.
Kinda like windows services and starting automaticlly or manually
4 votes -
Allow the user to sort using statements and references
Currently, it is very hard to find references on the "Additional References" and "Additional Namespace Imports" tabs when in the Query Properties window. This is harder when using LINQPad with enterprise applications that require a lot of references and using statements.
keep up the good work!
1 vote -
Team Foundation support
I've checked in my queries in TFS, it would be nice if LinqPad could checkout queries when i start editing them.
23 votes -
If user manually adjusts column widths in a query window - remember these settings.
If uses adjust the cols in a query result set, then if they run that query again and the result "shape" is the same, then use these adjusted col widths for these new results.
Only if the shape of the results changes from one run to the next is there any need to reset these (even in that case it could remember the widths I guess - on a per col basis)
4 votes -
Allow .zip as a driver extentions
Allowing a driver to be named .zip would simplify testing and debugging of new drivers. LINQPad could allow this but warn the user when the driver is added "Warning driver should be named .lpx please contact driver vendor to get this resolved" or something. This will really ease the fiddling around at dev/debug stage.
1 vote -
Add a "throw driver exceptions" capability.
This capability would cause an exception to be thrown by a driver when it gets a serious error preventing executuion. A outer catch could cartch these and write them to a driver test output window along with stack data.
In addition when running LINQPad under debug the debugger could be configured to break when an exception is thrown - although there is limited src available - this would still allow a developer to see stack traces etc and gain insights into what might be wrong.
When this new feature is disabled LINQPad would behave as it does now.1 vote -
Intercept and echo calls to Debug.WriteLine or other trace calls.
Adding a window that allows trace calls to be seen would aid in debugging drivers. These could be seen easily in LINQPad (perhap by enabling/disabling the visibility of these) when loading and testing a new driver or even allow such calls embedded in dynamically created source, to also log stuff - very hard to see otherwise.
6 votes
- Don't see your idea?