I am creating an object and would like to add a collection of sorts to it. I have a database table that looks like the following (for example):
Person Pet Role
Jim Cat 5
Jim Dog 3
Sue Bird 2
Sue Fish 3
My object will be associated with a person, like "Jim" in the above. I will call this the "Person" object. Is there a way to add a list of the animals, along with their role values into this object, so I can do something like this:
Peson.Name //Would return Jim
Person.Animals.Name //Would return Dog
Person.Animals.Role //Would return 3
and also to structure the Person class so it can do loops:
foreach Animal in Person.Animals
Can someone walk me through how to do this? Thanks.
I am guessing I first need to create the Animal object with the name and role method. But I am unsure how to add this to the Person class so it can be used like the example above.