.net mvc linq linq结果

Question

请看代码:如何将m.Division ("Divone，a")拆分为像"DivOne"，"a“这样的对象

public JsonResult GetData()
    {
        var series = (from m in db.Fields.AsEnumerable()
                      where m.tstatus == true
                      select new
                      {
                          name = m.Name,
                          data = new [] { m.Division }
                      }).ToArray();

        return Json(series, JsonRequestBehavior.AllowGet);
    }

结果

[{"name":"fff","data":["DivOne,a"]},{"name":"a","data":["a"]}]

我想要这样的结果

[{"name":"fff","data":["DivOne","a"]},{"name":"a","data":["a"]}]

图片在这里：enter image description here

Answer 1

将m.Division更改为m.Division.Split('，')

 public JsonResult GetData()
        {
            var series = (from m in db.Fields.AsEnumerable()
                          where m.tstatus == true
                          select new
                          {
                              name = m.Name,
                              data = new[] { m.Division.Split(',') }
                          }).ToArray();

            return Json(series, JsonRequestBehavior.AllowGet);
        }

Answer 2

@Sajid

谢谢你……这就是我想要的结果

public JsonResult GetData()
    {
        var series = (from m in db.Fields.AsEnumerable()
                      where m.tstatus == true
                      select new
                      {
                          name = m.Name,
                          data = m.Division.Split(',')
                      }).ToArray();

        return Json(series, JsonRequestBehavior.AllowGet);
    }

[{"name":"fff"，"data":"DivOne"，"a"}，{"name":"a"，"data":"a"}]

Answer 3

只需使用Split('，')表示除法，如下所示。

public JsonResult GetData()
    {
        var series = (from m in db.Fields.AsEnumerable()
                      where m.tstatus == true
                      select new
                      {
                          name = m.Name,
                          data = m.Division.Split(',')
                      }).ToArray();

        return Json(series, JsonRequestBehavior.AllowGet);
    }