Correct way to adding to JSON in Foreach loop C#

Question

I have code that give mi JSON file. But this JSON file have \ signs inside (string escape). How to change this code to remove \ signs?

public class Reservation
    {
        public string start { get; set; }
        public string end { get; set; }
    }

    [HttpGet]
    public IEnumerable<string> JSON()
    {
        var jsonString = "NO RESERVATIONS";

        var jsonList = new List<string>();

        foreach (var reservation in _context.ReservationModel)
        {
            var start = reservation.StartOfReservation.ToString("yyyy.MM.dd");
            var end = reservation.EndOfReservation.ToString("yyyy.MM.dd");


            var res = new Reservation
            {
                start = start,
                end = end,
            };

            jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(res);
            jsonList.Add(jsonString);

        }
        return jsonList;
    }

JSON:

["{\"start\":\"2022.03.22\",\"end\":\"2022.03.25\"}","{\"start\":\"2022.04.22\",\"end\":\"2022.04.25\"}"]

check this, stackoverflow.com/questions/14660897/…

Maytham Fahmi
– Maytham Fahmi

2022-03-19 11:14:50 +00:00
Commented Mar 19, 2022 at 11:14 — Maytham Fahmi
– Maytham Fahmi, Commented Mar 19, 2022 at 11:14

Serge · Accepted Answer · 2022-03-19 13:11:47Z

2

your json file is invalid

[HttpGet]
public  string GetJsonString()
{
    ....

       var resList = new List<res>();

        foreach (var reservation in _context.ReservationModel)
        {
            var start = reservation.StartOfReservation.ToString("yyyy.MM.dd");
            var end = reservation.EndOfReservation.ToString("yyyy.MM.dd");


            var res = new Reservation
            {
                start = start,
                end = end,
            };

            resList.Add(res);

        }
        var jsonString = Newtonsoft.Json.JsonConvert.SerializeObject(resList);
        return jsonString;
}

but I higly recommed you to use this syntax, it will be automatically serialized to Json.

[HttpGet]
public List<Reservation>  GetJson()
{
    ....

       var resList = new List<res>();

        foreach (var reservation in _context.ReservationModel)
        {
          .....
        }
       
        return resList;
}

edited Mar 19, 2022 at 13:11

answered Mar 19, 2022 at 13:06

Serge

44.4k4 gold badges26 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MarcinAWK Over a year ago

Thanks Serge. This is what I'm looking for!

Collectives™ on Stack Overflow

Correct way to adding to JSON in Foreach loop C#

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related