version 1.0.2005.1 final (self-servicing) VS2005 winforms

hiya,

I have a simple filter question. I want to filter an entityCollection.

private myProject.CollectionClasses.TblDeliveryProductsCollection currDeliveries;

there is a field in the entity named "deliveryId"

I think that I should be using a predicate to filter? All I want to do is the equivalent of:

WHERE deliveryId = 1 etc

I know it's a simple question, but can anyone help me out?

many thanks,

yogi

Yogi It would be something like this

IPredicateExpression filter = new PredicateExpression();
filter.Add(PredicateFactory.CompareValue(YourEntityFieldIndex.Field, ComparisonOperator.Equal, 1));

This is a direct copy from the manual 'best practices-->How do I' . I recomment that you have a quick look at it.

You mean in-memory filtering?

hiya,

yes, a simple in-memory filter. I am able to create the filter, according to the manual best practices.

However, for the life of me, I can't figure out how to APPLY this filter to the entityCollection.

Can anyone help?

cheers,

yogi

yogiberr wrote:

hiya,

yes, a simple in-memory filter. I am able to create the filter, according to the manual best practices.

However, for the life of me, I can't figure out how to APPLY this filter to the entityCollection.

Can anyone help?

In-memory filtering isn't build in yet, that comes in v2. The only option you have now is to manually traverse the collection and collect the ones which match.

Thinking outside the LLBLGen box for a moment, have you considered using the Filter property of a BindingSource (2005) or DataView (2003) object?

It would be a REALLY simple in memory filter and not provide the same support as the LLBL typed code, but may meet your needs.

hiya,

Well, I'll be doing some more complex stuff with the collection later, so i want to stick with an entityCollection.

it seems that the code below successfully filter the entityCollection:

 IPredicateExpression filter = new PredicateExpression();
            filter.Add(PredicateFactory.CompareValue(TblDeliveryProductsFieldIndex.DeliveryId, ComparisonOperator.Equal, 0));

currDeliveries.GetMulti(filter);

I'm not sure why it was mentioned that I'd manually have to iterate thru the rows

This seems to work fine.

many thanks,

yogi

yogiberr wrote:

I'm not sure why it was mentioned that I'd manually have to iterate thru the rows

Because this code does a refetch, and so isn't the same as in memory filtering