I have a problem when designing my classes when bringing data to and from the database.
I design my classes closely to the database fields.
For example CustomerId is a property in a class and also in a table.
My problem is that in a table called productCategory can have productId and productName
and product class can have productName and productId.
So we have a duplicate property called categoryId.
Is this normal in class design?