c# - Mapping to denormalized properties -


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