EF数据分组查询

 由于将mysql的数据进行分组显示在树形结构中。所以使用了下面的查询方式。由于数据库设计的不好，感觉代码比较乱

    public string Get()
        { 
            string result = "";
            using (var edm = new wlcloudEntities())
            { 
                var query1 = edm.group.GroupJoin(edm.project, a => a.Project, ch => ch.ID, (a, ch) => new
                {
                    id = a.ID,
                    text = a.Name,
                    children = ch.Select(order  => new { id = a.ID + "_"+ order.ID, text =order.Name }).ToList()
                }).ToList();

                result = JsonConvert.SerializeObject(query1);  
            }
            return result;  
        }

这是返回的json数据 

[ 
  {
    "Groupid": 6,
    "groupName": "主楼",
    "children": []
  },
 
  {
    "Groupid": 8,
    "groupName": "主配电室",
    "children": []
  },
  {
    "Groupid": 9,
    "groupName": "主配电室",
    "children": [
      {
        "id": "9_6",
        "Name": "风电项目"
      }
    ]
  }, 
  {
    "Groupid": 13,
    "groupName": "深井泵",
    "children": [
      {
        "id": "13_8",
        "Name": "210万吨焦化项目"
      }
    ]
  }
]