Which one is better:
I have a class "User" and "Profile". in "User" I'll have a property that will be associated with the "Profile". The two classes will be stored in two different tables "Users" and "Profiles". In table "Profiles" there will be foreign key to "Users" table".
In my "User" class, should I include a property of type "Profile" or just a "ProfileId" which reefers to the Profile id in the "Profiles" table?
thanks