Skip to content
← LINQPad Feature Suggestions

I suggest you ...

LINQPad Feature Suggestions

Categories

(thinking…)

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 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
anonymous shared this idea  ·   ·  Report…  ·  Admin →
declined  ·  AdminJoe Albahari (LINQPad) (CEO / Founder, LINQPad) responded  · 

In 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!

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • HAKAN commented  ·   ·  Report

    SELECT * FROM ADRES

  • Sudhir Patil commented  ·   ·  Report

    SELECT max(Sub.SubjectID) AS SubjectID,max(Sub.SubjectName) AS SubjectName, Sub.AreaDetails_ID,max(Area.Assessment_AreaName) AS Assessment_AreaName
    FROM tbl_Subject AS Sub INNER JOIN
    tbl_CCEAssessmentAreaDetails AS Area on Sub.AreaDetails_ID = Area.AreaDetails_ID INNER JOIN
    tbl_CCEComprehensiveType AS Comprehensive on Sub.ComprehenciveTypeID = Comprehensive.ComprehenciveTypeID
    WHERE Sub.CourseID = 22 AND Sub.status = 'A' AND Sub.GoverningBodyID = 1 AND Sub.ComprehenciveTypeID = 2
    GROUP BY Sub.AreaDetails_ID

  • Anonymous commented  ·   ·  Report

    LINQ is for people who don't understand SQL...

  • Ashish Kumar Gupta commented  ·   ·  Report

    Is it possible to convert sql statement into Linq statement using LinqPad?

    I want to convert this statement using linq pad my quey is

    SELECT * FROM TblSourceA FULL OUTER JOIN TblSourceB ON TblSourceA.First=TblSourceB.First OR TblSourceA.Last=TblSourceB.Last;

    because how i use or oprator in Linq query

  • nurullah commented  ·   ·  Report

    select * from CekSenet
    left join (select top 1 ceksenet.CariKartFk,ceksenet.CekSenetFk from CekSenet order by CekSenetPK desc ) acs on acs.CekSenetFk = CekSenet.CekSenetPK
    where CekSenet.CekSenetFk =0 and acs.CariKartFk = 8

  • Jason Short commented  ·   ·  Report

    What other tools? I have never seen anything that does that!