Lamda表达式实现Left join

[大麦芽糖]

var query = User.GroupJoin(Charge, u => u.Account, c => c.Account, (u, c) => new { u, c })
.Select(data => new AnalysisPlayer { Account = data.u.Account, PlayerName = data.u.Name, 
RegTime = data.u.CreateTime ?? DateTime.Now, Points = 此处如何写代码 });

public class AnalysisPlayer
{
        /// <summary>
        /// 玩家名称
        /// </summary>
        public string PlayerName { get; set; }
        /// <summary>
        /// 玩家账号
        /// </summary>
        public string Account { get; set; }
        /// <summary>
        /// 注册时间
        /// </summary>
        public DateTime RegTime { get; set; }
        /// <summary>
        /// 充值总数
        /// </summary>
        public int Points { get; set; }
}

[q107770540]

不知你想问什么

[大麦芽糖]

[Quote=引用 1 楼 的回复:]

不知你想问什么
[/Quote]
标题就是啊！

Points是附表Charge中的列，此语句实现Left join。数据集要按照AnalysisPlayer类的格式输出。现在前3列实现都很简单，最后一个Points列要如何实现，因为是左关联，Points列可能没有

[q107770540]

var query = User.GroupJoin(Charge, u => u.Account, c => c.Account, (u, c) => new { u, c })
.Select(data => new AnalysisPlayer { Account = data.u.Account, PlayerName = data.u.Name,
RegTime = data.u.CreateTime ?? DateTime.Now, Points =data.c==null?0:data.c.Points });