you can try this.... arrange table and column name according to your requirement.
var CategoriesAndProducts =
from category in Categories
join product in Products on
category equals product.Category into categoryProducts
from category in categoryProducts.DefaultIfEmpty()
select new
{
product.productname,
product.productID
};