Basically put, I have an "Identity" table that has an ID and username, I have another table that has entries "owned" by a person, for that reason, I need to have a FK that links to the Identity table.
For example: Class "Identity" - int ID, string username.
I was just wondering which of the following is best:
Class "test" - int ID, string data, Identity identity
Class "test" - int ID, string data, int identity_id
- with an annotation defining as foreign key.
I personally use the first, and seen that EF basically does the second behind the scene, but I was just wondering what the advantages/disadvantages are and what is best?