Hi,

I have two tables

The parent is Project and the child is ProjectAccount

I want to download the specific record from Project, with the ProjectAccount object that has a specific date.

The code is:

Dim PrefetchPath as IPrefetchPath2=New PrefetchPath2(CType(EntityType.ProjectEntity, Integer))

dim MyProject as New ProjectEntity(projectID)

Dim filter as IRelationPredicateBucket=New RelationPredicateBucket

filter.PredicateExpression.Add(PredicateFactory.Between( _ ProjectAccountFieldIndex.Date, _ elszamolasDate.AddDays(-1), _ elszamolasDate.AddDays(1)))

PrefetchPath.Add(ProjectEntity.PrefetchPath.ProjectAccountCol, 1, filter)

Here I get an Invalid Cust Exception.

I tried to ad the relation to MyProject, and then ad the relation to the filter, but the result was the same.

What amI missing?

Thanks

Gabor

Could you paste the stacktrace where you got the invalid cast exception?

Frans,

The newbiest question :

How to get the stacktrace, to show the LLBLGen parth oft the code?

Thanks

Gabor

Gabor wrote:

Frans,

The newbiest question :

How to get the stacktrace, to show the LLBLGen parth oft the code?

Thanks

Gabor

That stack trace is given with the exception by .NET . (you know, that long list of "at .... " lines)

Thanks Frans,

That stack trace is given with the exception by .NET . (you know, that long list of "at .... " lines)

The list not so long

{System.InvalidCastException} [System.InvalidCastException]: {System.InvalidCastException} HelpLink: Nothing InnerException: Nothing Message: "Specified cast is not valid." Source: "BLL" StackTrace: " at BLL.queryMan.GetProjectAndElszamolas(DataAccessAdapter& adp, Int32 projectID, DateTime elszamolasDate) in C:\VB7projectek\MunkaElszamolo\BLL\queryMan.vb:line 606" TargetSite: {System.Reflection.RuntimeMethodInfo}

So what's at this line: C:\VB7projectek\MunkaElszamolo\BLL\queryMan.vb:line 606 There the invalid cast is performed. Could you paste that code here please?

Found the solution,

My mistake was, that I added a relationPredicateBucket to the filter property of the prefetch collection instead of predicateExpression.

Thanks

Gabor

Glad it's solved!