Synnefo » Pithos MS Client

using Castle.ActiveRecord.Queries;

using NHibernate.Criterion;

        public static void RemovePaths(IEnumerable<string> removed)

        {

            var disjunction = new Disjunction();

            foreach (var path in removed)

            {

                disjunction.Add(Restrictions.On<FileState>(s => s.FilePath).IsLike(path, MatchMode.Start));

            }

            var query=QueryOver.Of<FileState>().Where(disjunction);

            var aq = new ProjectionQuery<FileState,Guid>(query.DetachedCriteria,

                        Projections.ProjectionList().Add(Projections.Id()));

            var ids=aq.Execute();

            FileState.DeleteAll(ids);

        }