C# ling to sql 左表连接
程序员文章站
2022-06-19 19:21:43
var begin_daily = from a in _postgreDbContext.tab1 join b in _postgreDbContext.tab2 on a.id equals b.merchant_id into a_left ... ......
var begin_daily = from a in _postgredbcontext.tab1 join b in _postgredbcontext.tab2 on a.id equals b.merchant_id into a_left from left_a in a_left.defaultifempty() where left_a.date.tostring("yyyy-mm-dd") == begin_date select new { left_a.id, left_a.balance, left_a.service_balance, left_a.paid_money };
上一篇: 如果想实现财富*,创业是一种选择
下一篇: 备孕吃芹菜对于身体好吗