**i have this SQL**

```
SELECT *
FROM  [dbo].[LeftHand]
        left outer JOIN [dbo].[Head]  ON [LeftHand].[ID] = [Head].[LeftHand_Id]
        WHERE [Head].[RightHand_Id] Not IN (59,60,63,64,65) or [Head].[RightHand_Id] is null 

```

---

```
        [Head]
        */  \*
        /    \
      1/      \1
[LeftHand]  [RightHand]       ([LeftHand may have more than one [RightHand]  )

```

As you can see i want to get all the [LeftHand] objects (include the ones that don't have any [RightHand]), but in case they have a [RightHand] then it's ID must be from this list (59,60,63,64,65)

**So how can i get the same result in LINQ ?**

LINQ to Entities,  

Framework 4

thanks