i've got pair of database tables looks like:
task - id : int (pk) - accountid : int (fk) taskstartinterval - taskid : int (pk, fk) - index : int (pk) - accountid: int (fk) - startdatetime : datetime2(0) - enddatetime : datetime2(0) there one-to-many relationship between these tables (task.id > taskstartinterval.taskid).
you'll notice i've denormalized accountid property - stored against taskstartinterval task support queries based on accountid & datetime. you'd imagine, accountid of taskstartinterval same of related task.
how can model denormalized property in entity framework? ideally i'd want hide property taskstartinterval altogether, have intelligence in there such looks @ related task property value. possible?
Comments
Post a Comment