Hi,

I am using the follwoing code to fetch an Entitycollection

Dim _auftraege As New EntityCollection(New MyAuftragskoepfeEntityFactory)
Dim _filter As IRelationPredicateBucket = New RelationPredicateBucket
Dim _prefetchPath As IPrefetchPath2 = _
        New PrefetchPath2(CType(EntityType.AuftragskoepfeEntity, Integer))

If MitPositionen Then
    If MitDokumente Then
    _prefetchPath.Add(MyAuftragskoepfeEntity.PrefetchPathAuftragspositionen).SubPath.Add( _
        MyAuftragspositionenEntity.PrefetchPathAuftragsPosDokumente)
    End If
    If MitArtikel Then
        _prefetchPath.Add(MyAuftragskoepfeEntity.PrefetchPathAuftragspositionen).SubPath.Add( _
            MyAuftragspositionenEntity.PrefetchPathArtikelstamm)
    End If
End If
_filter.PredicateExpression.Add(PredicateFactory.CompareRange(AuftragskoepfeFieldIndex.AuftragsNr, Auftragkeys))
_auftraege = New EntityCollection(New MyAuftragsHerkunftEntityFactory)

Me.Adapter.FetchEntityCollection(_auftraege, _filter, _prefetchPath)

The query generated references a different table (The columns retrieved in the select query are from a different table than Auftragskoepfe) I regenerated the code, checked if any files are write-protected and I still get the error.

Any help would be greatly appreciated

Best regards and a nice weekend!

You overwrite _auftraege with a different collection in the last line of your code: _auftraege = New EntityCollection(New MyAuftragsHerkunftEntityFactory)

Dear Otis,

I guess this is the kind of Friday-afternonn message that make you which you would be breeding sheep in Australia or anything else but not answering such question.

I promise to never again write anything on a friday afternoon without being absolutely sure that I am not doing some nonsense.

Greetings and a nice week

N. Brake

Heh