Ok, so this may be a dumb question but for whatever reason I can not seem to wrap my brain around how to do what I want to do.
So what I'd like to do is take some set of data from database tables, multiple records, and then store them into a class for use later. My first thought was to simply create a class with public properties that match up with the fields in the table. Make them all longchar. Then store the records in a delimited list in each of the fields. For example entry 1 of each property would be 1 record. Now one of the fields is already going to be a delimited list, of course I can use different delimiters, but i'd really like to not do that. I'd like to create multiple instances of the one class, without having to statically define them. I'm just not sure how, where to store each of these records. I'm sure it's an easy answer but again, my brain is not fully functioning today for whatever reason.
So what I'd like to do is take some set of data from database tables, multiple records, and then store them into a class for use later. My first thought was to simply create a class with public properties that match up with the fields in the table. Make them all longchar. Then store the records in a delimited list in each of the fields. For example entry 1 of each property would be 1 record. Now one of the fields is already going to be a delimited list, of course I can use different delimiters, but i'd really like to not do that. I'd like to create multiple instances of the one class, without having to statically define them. I'm just not sure how, where to store each of these records. I'm sure it's an easy answer but again, my brain is not fully functioning today for whatever reason.