How to write a Linq statement in SQL?

Question

I'm fairly new to using Linq in C# and I just want to know how a normal SQL statement will look like when compared to a Linq query?

I have this statement:

var query =
from b in db.Employee.Include(o => o.Position)
where b.Position.Position_Desc == "Junior" && b.Employee_ID == 5
select b;

So my actual question is how will this statement look if I were to write it in SQL?

You can execute this code against a real SQL server and use SQL profiler to see the actual SQL query — Yacoub Massad
– Yacoub Massad, Commented May 5, 2016 at 11:51

sgmoore · Accepted Answer · 2016-05-05 12:02:28Z

1

query.ToString() should return the SQL.

Or you can use LinqPad

answered May 5, 2016 at 12:02

sgmoore

16.1k6 gold badges46 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

valex · Accepted Answer · 2016-05-05 12:27:48Z

0

If there is a relation between Employees and Positions tables with foreign key say Employees.PositionId -> Positions.Id. Then you can use LEFT JOIN to write a similar SQL query:

SELECT Employees.*,
       Positions.*
FROM Employees
LEFT JOIN Positions ON Employees.PositionId = Positions.Id
WHERE Positions.Position_Desc = 'Junior'
      AND Employees.Employee_ID = 5

answered May 5, 2016 at 12:27

valex

24.2k7 gold badges47 silver badges62 bronze badges

Comments

Jitendra Tiwari · Accepted Answer · 2016-05-06 13:43:05Z

0

You can check your query in debug mode (see attach image)

answered May 6, 2016 at 13:43

Jitendra Tiwari

1,6913 gold badges16 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to write a Linq statement in SQL?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related