8,497
社区成员
发帖
与我相关
我的任务
分享
[Table("Charisma_User")]
[Serializable]
public class Charisma_User
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
[ForeignKey("GetGroupObj")]
public int GroupId { get; set; }
public virtual Charisma_Group GetGroupObj { get; set; }
}
[Table("Charisma_Group")]
[Serializable]
public class Charisma_Group
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
public virtual List<Charisma_SysModule> SysModuleList { get; set; }
}
[Table("Charisma_SysModule")]
[Serializable]
public class Charisma_SysModule
{
[Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
public int Id { get; set; }
[ForeignKey("GetGroup")]
public int GroupId { get; set; }
public virtual Charisma_Group GetGroup { get; set; }
}
from cu in db.Charisma_User
join cg in db.Charisma_Group
on cu.GroupId equlas cg.Id
from cs in db.Charisma_SysModule
on cs.GroupId equals cu.GroupId into t
from cs in t.DefalutIfEmpty()
select cu;