CODEWITHSUNDEEP
linq-to-sql
Amitabh Basu
Amitabh Basu

Reputation:

LINQ nested query

How can i write following SQL query using LINQ

SELECT priority 
FROM Active_SLA 
WHERE APP_ID = (
        SELECT APP_ID 
        FROM FORM_PAGES 
        WHERE PAGE_ADDRESS = @address
    ) 
AND PERSON_ID = (
        SELECT PERSON_ID 
        FROM PERSON_DEVICES 
        WHERE DEVICE_NUMBER = @devicenum
     )

Upvotes: 0

Views: 1096

Answers (1)

Jon Skeet
Jon Skeet

Reputation: 1504052

Try this (formatting oddness for the sake of avoiding wrapping...)

var query = from sla in db.ActiveSLA
            where sla.AppId == (db.FormPages
                         .Where(page => page.PageAddress == address)
                         .Single().AppId)
               && sla.PersonId == (db.PersonDevices
                         .Where(pd => pd.DeviceNumber == deviceNumber)
                         .Single().PersonId)
            select sla.Priority;

However, I'd be very tempted to do this as a join instead:

var query = from sla in db.ActiveSLA
            join fp in db.FormPages on sla.AppId equals fp.AppId
            where fp.PageAddress == address
            join pd in db.PersonDevices on sla.PersonId equals pd.PersonId
            where pd.DeviceNumber == deviceNumber
            select sla.priority;

Upvotes: 3

Related Questions