How to read values from array of objects in appsettings.json file

Question

My appsettings json file

       {
         "StudentBirthdays": [
                { "Anne": "01/11/2000"},
                { "Peter": "29/07/2001"},
                { "Jane": "15/10/2001"},
                { "John": "Not Mentioned"}
            ]
        }

I have a seperate config class.

public string GetConfigValue(string key)
{
    var value = _configuration["AppSettings:" + key];
    return !string.IsNullOrEmpty(value) ? Convert.ToString(value) : string.Empty;
}

What I have tried is,

 list= _configHelper.GetConfigValue("StudentBirthdays");

For the above I dont get the values.

How can I read the values(I want to read the name of the student and his birthday seperatly).

Any help is apreciated

@Llama you mean "_configHelper.GetSection("StudentBirthdays"); " ,after implementing a seperate method to GetSection in config class ? — rissa
– rissa, Commented Sep 24, 2021 at 2:59
I mean _configuration.GetSection, and yes, probably something like that in the _configHelper class to provide access to it. — ProgrammingLlama
– ProgrammingLlama, Commented Sep 24, 2021 at 3:06

ProgrammingLlama · Accepted Answer · 2021-09-24 03:23:08Z

6

You can obtain the birthdays using the following code:

// get the section that holds the birthdays
var studentBirthdaysSection = _configuration.GetSection("StudentBirthdays");

// iterate through each child object of StudentBirthdays
foreach (var studentBirthdayObject in studentBirthdaysSection.GetChildren())
{
    // your format is a bit weird here where each birthday is a key:value pair,
    // rather than something like { "name": "Anne", "birthday": "01/11/2000" }
    // so we need to get the children and take the first one
    var kv = studentBirthdayObject.GetChildren().First();
    string studentName = kv.Key;
    string studentBirthday = kv.Value;
    Console.WriteLine("{0} - {1}", studentName, studentBirthday);
}

Try it online

answered Sep 24, 2021 at 3:23

ProgrammingLlama

39.3k7 gold badges78 silver badges104 bronze badges

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

Comments

Serge · Accepted Answer · 2021-09-24 11:14:34Z

1

try this

using System.Linq;

public List<Student> GetStudentsFromConfig()
{
    return  _configuration
    .GetSection("StudentBirthdays")
    .Get<Dictionary<string, string>[]>()
    .SelectMany(i => i)
    .Select(ie => new Student {Name=ie.Key, DOB=ie.Value})
    .ToList();
}

test

items= _configHelper.GetStudentsFromConfig();

foreach (var item in items) Console.WriteLine($"Name: {item.Name} , DOB: {item.DOB} ");

result

Name: Anne , DOB: 01/11/2000 
Name: Peter , DOB: 29/07/2001 
Name: Jane , DOB: 15/10/2001 
Name: John , DOB: Not Mentioned

class

public class Student
{
    public string Name { get; set; }
    public string DOB { get; set; }
}

edited Sep 24, 2021 at 11:14

answered Sep 24, 2021 at 3:07

Serge

44.4k4 gold badges26 silver badges53 bronze badges

2 Comments

rissa Over a year ago

I have already implemeted model classes controlleres and everything.And it get value from other keys.As this student birthdays consist an array i find it difficult.Is there a way that i can accomplish this by using same set of file structure that i have created.because what i am trying to do is getting the name and birthday from from db and check whether it is similar to the data in the appsettings or not.

Serge Over a year ago

@rissa You should mention it in your question. I updated my answer. You can check again.

Peter Csala · Accepted Answer · 2021-09-24 11:16:48Z

-1

Try this: Create Model/Class like below:

public class StudentBirthday
{
   String Name,
   String Birthday
}

Then access values like this :

List<StudentBirthday StudentBirthdays = 
   _config.GetSection("Main:StudentBirthdays").Get<List<StudentBirthday();

edited Sep 24, 2021 at 11:16

Peter Csala

23.7k16 gold badges51 silver badges96 bronze badges

answered Sep 24, 2021 at 5:06

Sonali Londhe

12 bronze badges

1 Comment

Community Over a year ago

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

How to read values from array of objects in appsettings.json file

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related