Associate a note table with multiple Entity tables using Entity Framework 4

Question

Im after some advice on database / entity design (Im using a modeler for Entity Framework 4).

I have several objects ( Entity_1, Entity_2, Entity_3... Entity_n) Id like to be able to attach a note to each object, where each entry Entity_1can have 0 or more notes, as a wise for Entity_2, etc.

After some Googling and messing around Ive come up with next, but Im getting mine 0—1’s, 1-1’sand *-*’sall the intricate now could do with a reality check :), so Id like to know stack overflow suggestions on the best method for arhitektovaniya this scenario for the convenience and ease of programming.

I found two questions that are related to each other, but opinions seem to be divided. Id would also like to receive opinions in the context of using EF4 after creating the database.

• Linking notes to various objects in the database

• Best way to implement a note table for many Table objects in SQL

Option 1

Option 2

Option 3

Each entry has a globally unique identifier and the identifier refers to a note.

What are your thoughts?

Answer 1

From the point of view of data modeling, you need a reference entity table for notes for each of your entity tables (I know that they may not actually be tables, but you used the word “entity” :)).

Modeling from there is pretty easy.

.

EF4 ( ), , .

" " , , .