linq语法实现sql语句

[lovecrow521]

大家好！
对Linq语法不熟悉，请教各位专家，那位能把下面的语句给用linq语法给写出来，非常感谢！！
select * from (select JH_ID as id,'计划' as name,JH_WORK_CONTENT,JH_TIME_START as jobtime from yd_jh
union select JH_ID as id,'执行' as name,JH_WORK_CONTENT,JH_TIME_END as jobtime from yd_jh) t order by id,jobtime

[--小F--]

不会 linq 帮顶

[SQL77]

没用过LINQ转.NET版问

[丰云]

var tmpResult = ((from y in DataContext.yd_jh
select new {
id = y.JH_ID,
name = '计划',
y.JH_WORK_CONTENT,
jobtime = y.JH_TIME_START
}).Concat(from y in DataContext.yd_jh
select new {
id = y.JH_ID,
name = '计划',
y.JH_WORK_CONTENT,
jobtime = JH_TIME_END
})).orderby(p=>p.id).orderby(p=>p.jobtime )

[dawugui]

不懂，帮顶，学习，蹭分.

[lovecrow521]

太感谢foren_whb了
var tmpResult = ((from y in DataContext.yd_jh
select new {
id = y.JH_ID,
name = '计划',
y.JH_WORK_CONTENT,
jobtime = y.JH_TIME_START
}).Concat(from y in DataContext.yd_jh
select new {
id = y.JH_ID,
name = '计划',
y.JH_WORK_CONTENT,
jobtime = JH_TIME_END
})).orderby(p=>p.id).Thenby(p=>p.jobtime )
是不是应该用Thenby? 没有个和手的linq常用资料啊。要有能给我一份么？

[丰云]

到linq to sql版块去找，有好的学习资料。

[ningbojinxin]

没用过LINQ转.NET版问