linq把paymentcode一样的用，拼在一起怎么写？

[-一个大坑]

	select a2.payment_code, listagg(a2.agent_short_name, ',') within group(order by a2.payment_code) as addfrom 
	from
	(select b.payment_code, c.agent_code,c.agent_short_name 
			from dlr_payment_agent b, dlr_bd_agent c
	where b.agent_code=c.agent_code) a2 
		group by a2.payment_code

把dlr_payment_agent 和dlr_bd_agent 查询结果当一个表，然后这个表paymentcode一样的把那么用，拼在一起

var aa=from a in db.dlr_payment_agent 
             join b  in db.dlr_bd_agent  on a.agent_code equals b.agent_code
...................

[-一个大坑]

var agentNameList = (from a in BdAgentService.GetList()
                      join b in paymentAgentService.GetList() on a.AgentCode equals b.AgentCode
                      select new { PaymentCode = b.PaymentCode, AgentName = a.AgentShortName }).GroupBy(t => t.PaymentCode).Select(g => new { paymentCode = g.Key, AgentName = string.Join(",", g.Select(s => s.AgentName)) });

网上搜了下，虽然不太理解，不过已经搞定了

[非专业开发Five]

引用 1 楼 happy4944 的回复:

var agentNameList = (from a in BdAgentService.GetList()
                      join b in paymentAgentService.GetList() on a.AgentCode equals b.AgentCode
                      select new { PaymentCode = b.PaymentCode, AgentName = a.AgentShortName }).GroupBy(t => t.PaymentCode).Select(g => new { paymentCode = g.Key, AgentName = string.Join(",", g.Select(s => s.AgentName)) });

网上搜了下，虽然不太理解，不过已经搞定了

和select语句差别不大，稍微换换位置就能解决，没错我是来蹭分的

[-一个大坑]

引用 2 楼 xomix 的回复:

[quote=引用 1 楼 happy4944 的回复:]

var agentNameList = (from a in BdAgentService.GetList()
                      join b in paymentAgentService.GetList() on a.AgentCode equals b.AgentCode
                      select new { PaymentCode = b.PaymentCode, AgentName = a.AgentShortName }).GroupBy(t => t.PaymentCode).Select(g => new { paymentCode = g.Key, AgentName = string.Join(",", g.Select(s => s.AgentName)) });

网上搜了下，虽然不太理解，不过已经搞定了

和select语句差别不大，稍微换换位置就能解决，没错我是来蹭分的[/quote] https://bbs.csdn.net/topics/392396290 看下这个问题