I have a class called Player in the business layer of my web application.
Player class has fields PlayerID, CategoryID and CountryID
A function in Player Class calls a function in PlayerDB Class in the Data Access Layer which in turn calls a stored proc which returns data for PlayerID, CategoryID (foreign key to Category table) and CountryID(foreign key to Country table) from the Player table.
I now have a situation where I want to add Country Name and Country Image (url path) to the above call, returning the new fields from the Country table for each CountryID.
My question is, do I add the country name and country image as additional fields to the Player class or do I have new classes called Country(BLL) and CountryDB(DAL) and a new stored proc?
I want to do what is best practice rather than what may be the easiest way.
If it is relevant I am using ASP.NET, VB.NET and SQL2005.
As you can probably tell I am a newbie so forgive me if I have not used the correct terminology in my question. I hope you get the idea.