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'
添加回答
舉報
0/150
提交
取消