Linq 中的 left join

表A User:

表B UserType:

Linq: from t in UserType join u in User on t.typeId equal u.typeId into newtable from newtable.DefaultIfEmpty()

　　　　select table in newtable;