Retrieve Json With Entityframework Core

I have store procedures returning json, thanks to for json path. How do you consume them with entity-framework-core? The following doesn't work: var foo = _db.Set()

Solution 1:

After searching on google for a while I understood is not supported yet. If you don't have a model in the context you can't retrieve data with entityframework, point: https://docs.microsoft.com/en-us/ef/core/querying/raw-sql and https://github.com/aspnet/EntityFrameworkCore/issues/1862

I resolved doing it the old way:

var jsonResult = new System.Text.StringBuilder();
  /*"using" would be bad, we should leave the connection open*/var connection = _db.Database.GetDbConnection() as SqlConnection;
  {
    await connection.OpenAsync();

    using (SqlCommand cmd = new SqlCommand(
        "Mine",
        connection))
    {
      cmd.CommandType = CommandType.StoredProcedure;

      cmd.Parameters.Add("@customerid", SqlDbType.NVarChar).Value = _user.guid;

      using (SqlDataReader reader = await cmd.ExecuteReaderAsync())
      {
        if (!reader.HasRows)
        {
          jsonResult.Append("[]");
        }
        else
        {
          while (reader.Read())
          {
            jsonResult.Append(reader.GetValue(0).ToString());
          }
        }
      }
    }
  }
  var raw = JArray.Parse(jsonResult.ToString());

  var ret = raw.ToObject<List<SiteData>>();

I am in doubt if it's better to explicitly close the connection or not.