Linq选择不同的列合而为一 [英] Linq select different column into one

问题描述

我有3张桌子

Person
--------
personname


student
-------
studentid
address
personid


teacher
--------
teacherid
address
personid

我的linq查询是

var p=from p in db.person
    join s in db.student
    on p.personid equals s.personid
    join t in db.teacher
    on p.personid equals t.personid
    select {address=????};

我如何在一个字段中选择学生和老师的地址????

How can i select both student and teacher address into one field????

推荐答案

select new { address = s.address + " " + t.address };

这应该起作用-用所需的分隔符更改".

This should work - change the " " with whatever separator you like.

这篇关于Linq选择不同的列合而为一的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！