I need some smart objects to retrieve some lookup values from SQL. Each smart object will have two methods, 1 to return a list of ID's and values, and 1 to return a specific value matching a given ID.
It seems to me that the idea behind smart objects would be for me to have 4 different objects to handle the 4 different lookups I need to perform... but that would create multiple SQL connections, so is it good practise to put all these methods into one object?
Thanks