Use this tag for questions related to the conversion of SQL statements into LINQ statements.
Questions tagged [sql-to-linq-conversion]
243 questions
-4
votes
1 answer
Converting SQL to Linq ("WHERE EXISTS")
Can anyone help me to convert this SQL into LINQ?
SELECT * FROM Room_Type b
WHERE Exists(
SELECT *
FROM Room a
WHERE a.RoomId NOT IN
(SELECT r.RoomId
FROM Reservation r
WHERE NOT (r.DepartureDate<='2015-02-16' OR r.ArrivalDate >…
user3405577
- 1
- 3
-4
votes
1 answer
How to perform multiple joins in LINQ
I have a stored procedure that I'm converting to LINQ, but I'm a little stuck. Here's the SQL:
select
@name = tp.Name
, @Entity = tc.Entity
, @Name …
Naruto
- 9,476
- 37
- 118
- 201
-4
votes
1 answer
if condition in IQueryable Join in LINQ query (Convert SQL to LINQ)
As I need to convert following MS SQL Query in to Linq in C#
As I have tryed with IQueryable but not able to do .
As in that we need to check if condition is true then only need to go for join with table
Thanks in adv.
SELECT @sqlQuery = 'SELECT…
BJ Patel
- 6,148
- 11
- 47
- 81