LINQ to Entities 不识别方法“System.String ToString()”，因此该方法无法转换为存储表达式。

错误代码：

List<ucSiteTree> ZoneInfo = (from z in container.Zone
select new ucSiteTree()
{
id = z.ZoneCode,
pId = "0",
name = z.ZoneName.ToString(),   //.tostring() 报错   
open = false


}).ToList();

正确代码：

List<ucSiteTree> ZoneInfo = (from z in container.Zone.ToList()
select new ucSiteTree()
{
id = z.ZoneCode,
pId = "0",
name = z.ZoneName.ToString(),    
open = false


}).ToList();

linq 只是sql     当tolist()  才是得到数据