DevForce 2009: Data Caching



var member = dataset.ExecuteQueryForEntity<Member>((from mem in dataset.Members

    where mem.MemberId == "754402"

    select mem));

and then I iterate through the Member's ActualCoverages collection and access the ActualCoverage's CoverageIntent link (CoverageIntent is a table that ActualCoverage links to). For Example:



foreach(var ac in member.ActualCoverages)

{
    if(!ac.CoverageIntent.IsNullEntity)

    {
         if(!ac.CoverageIntent.Employer.IsNullEntity)

              Console.WriteLine(ac.CoverageIntent.Employer.EmployerName);

    }
}

Several of the ActualCoverages link to the same CoverageIntent (3478c) and I was expecting that the first time that the CoverageIntent is accessed, it would need to go to the DB, but then subsequent requests would get it from the cache because even though we are accessing the CoverageIntent from different ActualCoverages, it is the same coverageintent and should already be in the local cache.

Am I doing something wrong? I can see in the Trace Viewer that the same query is getting called over and over trying to get the same CoverageIntent.

Thanks,

Dan