紧急求助!!!请高手帮忙!!!一道关于SQL to LINQ的问题(50)。
小弟刚接触linq,现在手里有个SQL语句,想把他转成linq,研究一下午了,请各位朋友帮忙看看,在群里也发过这个问题,不过大家都说复杂,所以就到这里来了,请高手现身!兄弟我不胜感激!!!下面是已写好的SQL语句,已做过测试,无任何问题。请高手过目:
SELECT AnnouncementID, AnnouncementTitle, CourseInstanceID, CourseClassID, AnnouncementContent, CreateTime, CreateUser, ExpiryDate, Active
FROM Announcement
WHERE (CourseClassID IN
(SELECT ClassID
FROM CourseClass
WHERE (CourseInstanceID IN
(SELECT DISTINCT TimeTable.CourseInstanceID
FROM TimeTable INNER JOIN
ACL ON TimeTable.TimeTableID = ACL.objectid
WHERE (ACL.roleid = '7') AND (ACL.isgroup = 'False') AND (ACL.userid = 'Z1000'))))) --------------------编程问答-------------------- 大家都来看看啊!谢谢了! --------------------编程问答-------------------- var p= from p in db.Products
join c in db.Categories
on p.CategoryID equals c.CategoryID
select p.ProductName;
参考 --------------------编程问答-------------------- 谢谢wuyq11的回复,不过这个答案应该和这个问题没太大关系。不过还是很感谢。 --------------------编程问答-------------------- --------------------编程问答-------------------- 搞这么复杂干什么呀? 一口吃不下就多要几下了,小心噎死。 --------------------编程问答-------------------- var query1=(from A1 in contex.TimeTable join A2 in contex.ACL on A1.TimeTableID equls on A2.objectid where A2.roleid =7 and A2.isgroup =flase and A2.userid ="Z2100"
where A1.CourseInstanceID). DISTINCT ().toArry();
var query2=form A3 in contex.CourseClass where CourseInstanceID in "+query1+"
select A3.ClassID ;
.............. --------------------编程问答-------------------- 不是直接从sql转,要先mapping。。。
补充:.NET技术 , LINQ