I have a database with events, each event has multiple organizers and multiple classifications. I am wondering the best manner in which to fill a dataset with the data so I can map the dataset to my event class. Any advice would be greatly appreciated.
A little framework - I have a eventID that is a foreign key in two tables one that contains organizerID and the other that contains a classificationID. I can easly query the database three times and get the data. Is that the best way? Or is it possible to get all the data in a single dataset?