complex filters in searchservice

In a search service i want an expression like this, but it throws a LINQ error. de parameter for adddays cannot be a reference to a field.

filter = x => x.Acco.AccoOwnerId == accoOwnerId &&
x.Status == "Reserved" &&
x.Created.Value.AddDays(x.Acco.DaysToExpire.Value).CompareTo(DateTime.Now) < 0;

How do you solve this kind of filters in a search service.
I'm using cocktail with devforce 2010

Thanks in advance
                    

Yes forgot to mention i'm using silverlight. And Sqlfunctions are not available in my DomainServices.SL?

Sorry for the late reply.

Thanks for the info. This will do the job

Just subclass Repository<T>, override the GetFindQuery and GetKeyQuery methods and compose the queries using your named query as the base query.

May be the suggestion is usefull to add an a virtual GetQuery in the Cocktail repository.cs and change the GetFindQueries to use this query.
It will certainly enhance the use of namedqueries.

public virtual IEntityQuery<T> GetQuery()
    {
      return EntityManager.GetQuery<T>();
    }

    //Override ivm NamedQuery
    protected override IEntityQuery<T> GetFindQuery(Expression<Func<T, bool>> predicate, Func<IQueryable<T>, IOrderedQueryable<T>> orderBy, string includeProperties)
    {
      IEntityQuery<T> query = GetQuery();            //EntityManager.ExpiredBookings;

      if (predicate != null)
        query = query.Where(predicate);
      if (orderBy != null)
        query = (IEntityQuery<T>)orderBy(query);
      if (!string.IsNullOrWhiteSpace(includeProperties))
        query = ParseIncludeProperties(includeProperties)
            .Aggregate(query, (q, includeProperty) => q.Include(includeProperty));

      return query.With(DefaultQueryStrategy);
    }

Edited by jkattestaart - 03-Apr-2013 at 11:55pm