5 results found
-
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 votesIn general, LINQ is a higher-level (more abstract) querying language than SQL and this creates some major scope for translation loss in a SQL→LINQ direction. For one, LINQ emits shaped results whereas SQL emits flat result sets. The upshot is that an automatic translation from SQL to LINQ will often have to perform more of a transliteration than translation – and generate examples of how NOT to write LINQ queries. For this reason, I’m loathed to implement such a feature. It would be rather like writing a tool to convert VB6 to C# 4, and then using the output to “learn” C# 4.
To use LINQ properly, you must learn to translate your requirements DIRECTLY into LINQ. If you think first in SQL and then translate to LINQ, you’ll get the worst of both worlds!
-
8 votes
There’s nothing to do here, as far as I know.
-
Ctrl + U to set focus on database selection combo
As per SSMS functionality.
1 voteCtrl+U uncomments in LINQPad. Alt+D focuses the database combo.
You can also drag the database from the Schema View onto the query – this is sometimes quickest.
-
an option to turn off autocompletion
There are some very complex queries where the autocompletion works extremely slow and thus doesn't let edit the query (it stuck every few seconds).
An option to turn-off the autocompletion should be introduced for these cases.Thanks
1 voteThe performance issues should all now be resolved – let me know if you’re having any further problems.
-
1 vote
(see comment: this is impossible in C#)
- Don't see your idea?