求一条linq语句。

Question

var expression = from d in this.db.MS_Deposit
join g in this.db.MS_Gold on d.Account equals g.Account
where d.IsDeposit == 1 && d.Status == 1 && g.GoldStatus == 11
&& d.CreateTime >= start && d.CreateTime <= end && g.CreateTime >= start && g.CreateTime <= end
select new { Account = d.Account, Deposit = d.MjMoney, Gold = g.MjMoney, CreateTime = d.CreateTime };

 

我是这样写的，这样不对。

this.db.MS_Deposit 按条件有1条数据。

条件为： d.IsDeposit == 1 && d.Status == 1 && d.CreateTime >= start && d.CreateTime <= end

this.db.MS_Gold 按条件有0条数据。

条件为：g.GoldStatus == 11 && g.CreateTime >= start && g.CreateTime <= end

期望查询出一条数据：Account=123, Deposit =50, Gold = 0, CreateTime = '2017-1-1'

Answer 1

你是要left join么？on .... into tmpfrom obj in tmp.DefaultIfEmpty()where....