关于SQL语句转换成linq语句

Question

SELECT * FROM dbo.[USER] u,
(SELECT ua.User_Attention_Object_Id FROM dbo.User_Attention ua,dbo.[USER] u
WHERE u.User_Id=ua.User_Attention_User_Id AND ua.User_Attention_User_Id=3) uaid
WHERE u.User_Id=uaid.User_Attention_Object_Id

还望好心人帮我一下，感激不尽！！

Answer 1

var uaid = from us in User_Attention
select ua.User_Attention_Object_Id
where u.User_Id==ua.User_Attention_User_Id && ua.User_Attention_User_Id==3;
var query = from u in User
WHERE u.User_Id==uaid.User_Attention_Object_Id
select u;