SQL Server and JSON and c#

create_object_from_json.cs

internal static async Task<IDataResponse<TResponse>> BuildResponse<TResponse>(string message)
{
    var response = new DataResponse<TResponse>();

    if (!string.IsNullOrEmpty(message))
        response.Body = await JsonConvert.DeserializeObjectAsync<TResponse>(message, SerializerSettings()).ConfigureAwait(false);

    return response;
}

internal static JsonSerializerSettings SerializerSettings()
{
    return new JsonSerializerSettings
    {
        Converters = new List<JsonConverter> { new StringEnumConverter { CamelCaseText = true } },
        NullValueHandling = NullValueHandling.Ignore
    };
}

read_json_data_sql_server.cs

using (var command = new SqlCommand(dataRequest.CmdText, SqlConnection)
{
    CommandType = dataRequest.CommandType
})
 {
    command.Parameters.AddRange(dataRequest.Parameters.ToArray());

    var reader = await command.ExecuteReaderAsync().ConfigureAwait(false); ;
    if (reader.HasRows)
    {
      while (reader.Read())
      {
        jsonResult.Append(reader.GetValue(0).ToString());
      }
    }
    reader.Close();
}

sql_server_json1.sql

SELECT 
    Id, 
    UserName, 
FROM dbo.Accounts
FOR JSON PATH

sql_server_json2.sql

SELECT 
    Id, 
	  UserName, 
FROM dbo.Accounts
    WHERE Id = @AccountId
FOR JSON PATH, WITHOUT_ARRAY_WRAPPER