求一条linq语句。

Question

var expression = from d in this.db.MS_Depositjoin g in this.db.MS_Gold on d.Account equals g.Accountwhere d.IsDeposit == 1 && d.Status == 1 && g.GoldStatus == 11&& d.CreateTime >= start && d.CreateTime <= end && g.CreateTime >= start && g.CreateTime <= endselect 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 <= endthis.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 tmp

from obj in tmp.DefaultIfEmpty()

where....