While your original query seems to miss a table prefix for the Location field in the select list, I have assumed it comes from the Locations table.
Your LINQ query would be:
from c in Category
from l in Locations
join ct in somechildtable on c.ID equals ct.CategoryID
select c.Name, l.Location