So let's say we have these two tables:

```
    CARS
    ID   CAR_MODEL 
    11   Mustang          
    22   Camaro           
    33   F-150     

    PARTS
    ID   CAR_ID  PART_NAME       
    1    11      Steering Wheel  
    2    22      Steering Wheel 
    3    22      Headlights     

```

**NOTE: there is no foreign key relationship in the database between the `PARTS.CAR_ID` and `CARS.ID` columns.**

---

Without the foreign key, what sort of linq query would be used to obtain these results:

```
    CARS
    ID   CAR_MODEL        PART_NAME_LIST
    11   Mustang          Steering Wheel
    22   Camaro           Steering Wheel, Headlights
    33   F-150            (null)

```

---

Environment: SQL Server 2014, linq-to-sql

---

edit: here is what I have so far, but this results in 4 rows in the results (2 for Camaro), instead of 3, and it does not include any parts.

```
from C in db.CARS
join P in db.PARTS on C.ID equals P.CAR_ID
select new{
   ID = C.ID,
   CAR_MODEL = C.CAR_MODEL,
   PART_NAME_LIST = ???
} 

```