linq 的子查询怎么写?
例如这样的
select id,(select top 1 key from table where keyid=id) as name from table2
我用
select new LineSortResult{
id=f.ID,
price1=((from price in ....).Take(1).First())
};
类似的句子报错 提示:
Method 'System.String ToString(System.String)' has no supported translation to SQL.