例如这样的

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.