请问关于linq左连接的有关问题

请教关于linq左连接的问题
数据结构大概是这样：

C# code

class Category(){    public int Id {get;set;}    public int ParentId {get;set;}    public string Name {get;set;}}

SQL code

select c.*, p.Name as ParentNamefrom Category as cleft join Category as pon c.ParentId = p.Idwhere c.Id=1

C# code

from c in Category.Where(c => c.Id == 1)join p in Categoryon c.ParentId equals p.Id into catesfrom cate in cates.DefaultIfEmpty()select new{    c,    ParentName = p.Name};

C# code

from c in Category.Where(c => c.Id == 1)join p in Categoryon c.ParentId equals p.Id into catesfrom cate in cates.DefaultIfEmpty()select new{    c,    ParentName = cate.Name};
[解决办法]
探讨

数据结构大概是这样：
C# code

class Category()
{
    public int Id {get;set;}
    public int ParentId {get;set;}
    public string Name {get;set;}
}



我想写出这样的效果：
SQL code

select c.*, p.Name as ParentNam……