Returning multiple rows for class (OOP)
My question is what should I do if I'm using Objects (OOP) and I want to return multiple rows in my object? Logically, my object should always contain only one row from the database right? What should I do if I want to get all or some of Employees if I have an Employee Class. I've searched to many websites but can't seem to find any. Are there any best practices for this? I'm using stored procedures and oop for this.
Thanks.