Visual Basic

satc wrote:

In this case , I can't use a foreign key with the field ObjectID because it need
to be flexible ( related with different tables ) and I don't know if this is
possible.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Quote:

But also , if I keep only the id , and add another field that keep the table name , how can I read with entity framework ?

Sascha Lefèvre wrote:

But how could the non-worst case look like?

Sascha Lefèvre wrote:

(Maybe I'm having a stupid moment..)

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

Dim Ename as string
......
......
Dim query=From t in context.[Ename]..... select t

• If I create a FK for each table in the Event table , the event table will became very huge . Imagine 80-90 Fields only for these FK.
• If I keep a event table for each table then , will be more complicated :
  Imagine 80-90 tables more on my database , and what about a query like this : " Display all the events in database on date 1/1/2015 " And after creating a report with these ???

// querying events on a certain day regardless of specific type
DateTime dayOfInterest = new DateTime(2015, 1, 1);
var events = context.Events.Where(e => e.Date == dayOfInterest);


// querying events of a specific type
var allUserEvents = context.Events.OfType<UserEvent>();