adlerpagliarini

• Input

@"{ 'name': 'Adler', 'secondName': 'Pagliarini',
    'obj1': { 'A': 1 },
    'obj2': { 'B': 2 },
    'objInArr': { 'B': 'B', 'C': { 'CC': 'CC', 'D': { 'DD': 'DDD' } }, InArr: [{ 'Arr': 'Arr_1' }, { 'Arr': 'Arr_2' }] },
    'ArrayN': [{ 'Array1': 1 }, { 'Array1': 11 }, { 'ArrayOfArray': [{ 'AofA': 'AofA_1' }, { 'AofA': 'AofA_2' }] }],
    'ArrayValues': [33, 99]
}";

adlerpagliarini

// https://www.codeproject.com/Questions/1128427/JSON-to-CSV-converter
public static class JsonToCsv
{
public static void JsonStringToCSV(string jsonContent)
{
    XmlNode xml = JsonConvert.DeserializeXmlNode("{records:{record:" + jsonContent + "}}");
    XmlDocument xmldoc = new XmlDocument();
    xmldoc.LoadXml(xml.InnerXml);
    XmlReader xmlReader = new XmlNodeReader(xml);
    DataSet dataSet = new DataSet();

adlerpagliarini

using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;

namespace JsonParser
{
    class Program
    {

adlerpagliarini

public class Startup
{
  ...

  public void Configure(IApplicationBuilder app, IHostingEnvironment env)
  {
      ...
      app.UseMvc(routerBuilder =>
      {
          // 2. Enable Dependency Injection on current routes

adlerpagliarini

public static class ODataEntitiesConfiguration
{
    public static IEdmModel GetEdmModel(IServiceProvider provider)
    {
        var builder = new ODataConventionModelBuilder(provider);

        builder.EntitySet<Developer>(nameof(Developer)).EntityType
               .Expand(SelectExpandType.Automatic)
               .Filter()
               .OrderBy()

adlerpagliarini

public class Startup
{
  ...

  public void Configure(IApplicationBuilder app, IHostingEnvironment env)
  {
      ...
      app.UseMvc(routerBuilder =>
      {
          // 2. Enable Dependency Injection on current routes

adlerpagliarini

...
public class DeveloperController : ControllerBase
{
    ...

    [HttpGet]
    [Route("{id}")]
    // 4. Enable OData
    [EnableQuery()]
    public async Task<ActionResult<Developer>> Get(int id)

adlerpagliarini

public class Startup
{
    public Startup(IConfiguration configuration)
    {
        Configuration = configuration;
    }

    public IConfiguration Configuration { get; }

    public void ConfigureServices(IServiceCollection services)

adlerpagliarini

public class Startup
{
    public Startup(IConfiguration configuration)
    {
        Configuration = configuration;
    }

    public IConfiguration Configuration { get; }

    public void ConfigureServices(IServiceCollection services)

adlerpagliarini

[Produces("application/json")]
[Route("api/[controller]")]
public class DeveloperController : ControllerBase
{
    private readonly DatabaseContext _context;

    public DeveloperController(DatabaseContext context)
    {
        _context = context;
    }