TSQL ‘IN’ Equivalent in LINQ

            var q = from l in context.RoadAlert_Location
                    join at in alertTypeIds
                    on l.AlertTypeId equals at
                    select l;

            foreach (RoadAlert_Location location in q)
            {
                locations.Add(MapLocation(location));
            }