linq to ef选择新数据并转换为json失败 [英] linq to ef select new data and convert to json fail

问题描述

vaScriptSerializer js = new JavaScriptSerializer();
var temp1 = db.aaa.Join(db.bbb, t => SqlFunctions.StringConvert((decimal)t.id).Trim(), t1 => t1.id, (t, t1) => new
            {
                id = t.id,
                text = t.name,
                state = "closed",
                children = new
                {
                    id = t1.id + "1",
                    text = t1.text,
                },
            });
  return js.Serialize(temp1);

这是我的linq代码，我想在网页中使用jquery tree生成树菜单。但是linq生成的数据是

this is my linq code, i want use jquery tree generate tree menu in web page.but linq generated data is

[{"id": 1, "text": "1", "state": "closed","children": {"id": "11","text": "a"}}]

我想生成

[{"id": 1, "text": "1", "state": "closed","children": [{"id": "11","text": "a"}]}]

json在子节点中丢失了一对括号。我想问一下如何修改linq代码以生成正确的json。

the json lost one pair of brackets in children node. i want to ask how to modify the linq code to generate right json.

推荐答案

这篇关于linq to ef选择新数据并转换为json失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！