关于sql 语句写成linq

[sheeran_x]

新手求教,
以下sql怎么转成Linq?

select * from tb_artist where artistid = (
select artistid from tb_album where albumid= 110014
)

[cy_kvein]

var linq= from t in tb_artist join b in tb_album on t.artistid equals b.artistid where b.albumid= 110014 select new { t.xxx, b.xxx }

[sheeran_x]

问题解决了,Thank you