select *,(case when (select Count(*) from VOD_VodOrderItemview where
MovieId=VOD_Movie.id and CreatorId=1)>0 then '已选' else '未选' end) as state from VOD_Movie如上面语句一样 动态增加个state的列,语句应该怎么写。
var obj = (from d in XX.VOD_Movie where .... select d);
这语句要怎么改。
MovieId=VOD_Movie.id and CreatorId=1)>0 then '已选' else '未选' end) as state from VOD_Movie如上面语句一样 动态增加个state的列,语句应该怎么写。
var obj = (from d in XX.VOD_Movie where .... select d);
这语句要怎么改。
{
D=d,
State= VOD_VodOrderItemview.Contains(i=>i.MovieId==d.id && i.CreatorId==1)? "已选":"未选"
}
换种思路能直接传入sql语句么,如select getdate()
任意语句都可执行?
能sql就能换成linq执行
看你上面写的 这应该是个表 并且里面的movieid应该是movie表的外键
var obj = (from d in XX.VOD_Movie where .... select d);
这样是出来的是 整个VOD_Movie表
而VOD_Movie中有 列1列2列3
我现在要这显示数列1和列2要怎么写
var obj = (from d in XX.VOD_Movie where .... select d.列1);那列2 呢?