I seem to be having a problem with the following

void SaveSubCase(SubCaseEntity subCase)
{
da = new DataAccessAdapter(Connection.PTCDB, true);
da.SaveEntity(subCase, false);

IPrefetchPath2 prefetchPath = new PrefetchPath2((int)EntityType.SubCaseEntity);
IPrefetchPathElement2 subCaseDetailNode = prefetchPath.Add(SubCaseEntity.PrefetchPathSubCaseDetail);  
IPrefetchPathElement2 caseDetails = subCaseDetailNode.SubPath.Add(SubCaseDetailEntity.PrefetchPathCaseDetails);
caseDetails.SubPath.Add(CaseDetailsEntity.PrefetchPathPeople);

//SubCaseEntity sc = new SubCaseEntity(subCase.Id)
da.FetchEntity(subCase, prefetchPath);
}

When I execute this I do not get the CaseDetailsEntity prefetched as expected. SQL Profiler shows the proper SQL statements being executed. If I uncomment sc and da.FetchEntity(sc, prefetchPath) all prefetches are done as expected. Is there something wrong with the code sequence above?

Thanks

SQL Profiler shows the proper SQL statements being executed

Try to run those statements against the database to see if they return valid results.

I did run the SQL statements and they did produce the proper results. Those results did not appear to be reflected in the entities when the subCase entity was re-used, but were reflected in the entities when a new SubCaseEntity was created and used.

Use a context to refetch using a prefetch path in existing entities. So add the root, existing entities to the context, then fetch the entities again with the prefetch path.