I know this is a simple question and I am yet a newbie.
I want to return data by joning 2 tables. "Products" table and "ProductCategory" Table.
In my DAL I have a "Products" class and also a "ProductCategory" class. So do I have to create a new class that has both properties of the Products class and Product Category class? Isn't there any other efficient way to do that?
I searched the net for a whole day now but i couldn't find an answer. I would be glad if you can provide some help?