Sunday, June 21, 2009

Use buckets for search multiple condition

public EntityCollection GetPagesForNavByAppId(int AppId)
{
IRelationPredicateBucket bucket = new RelationPredicateBucket(PageFields.AppId == AppId & PageFields.IsActive == true);
ISortExpression sort = new SortExpression(PageFields.NavOrder | SortOperator.Descending);
EntityCollection pages = new EntityCollection();

using (DataAccessAdapter adapter = new DataAccessAdapter())
{
adapter.FetchEntityCollection(pages, bucket, 0, sort, null);
return pages;
}
}

No comments:

Post a Comment