实体框架处理过程返回JSON

Question

我的存储过程以JSON格式返回数据。例如

{
  "StoryData": [
    {
      "UserStoryId": 141204
     }]
}

如何从实体Frameworkside以JSON格式采用此？

我尝试了： -

using (MyWizard_ARA_AppEntities context = new MyWizard_ARA_AppEntities())
                {
                    log.Info("Database connected successfully");
                    log.Info("GET_AMBIGUITYANALYSIS_RESULT procedure called");                    
                    return context.GET_AMBIGUITYANALYSIS_RESULT().ToArray();
                }

，但这没有给我适当的结果。

请帮助。

编辑： -

 public virtual ObjectResult<string> GET_AMBIGUITYANALYSIS_RESULT()
        {
            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<string>("GET_AMBIGUITYANALYSIS_RESULT");
        }

Answer 1

您应该从 GET_AMBIGUITYANALYSIS_RESULT过程中返回JSON的返回JSON到对象;

using (MyWizard_ARA_AppEntities context = new MyWizard_ARA_AppEntities())
{
    log.Info("Database connected successfully");
    log.Info("GET_AMBIGUITYANALYSIS_RESULT procedure called");
    var result = JsonConvert.DeserializeObject<Ambiguityanalysis>(context.GET_AMBIGUITYANALYSIS_RESULT());
    return result;
}
public class StoryData
{
    public int UserStoryId { get; set; }
}
public class Ambiguityanalysis
{
    public List<StoryData> StoryData { get; set; }
}