Disctinct from the table

Question

ICriteria crit = session.CreateCriteria();

                foreach (ICriteriaItem<object> param in filters)
                {
                    crit.Add(Expression.Eq(param.PropertyName, param.FilterValue));
                }

                crit.SetProjection(Projections.Distinct(Projections.ProjectionList()));

-- disctinct not working can you please help me

                crit.AddOrder(new Order(sortField, sortOrderAscending));

                crit.SetFirstResult(pageNumber * pageSize);

                crit.SetMaxResults(pageSize);

                transaction.Commit();

                return crit.List<IHCOSpendTable>();

Answer 1

You need to add property maps to the ProjectionList()

crit.SetProjection(Projections.Distinct(Projections.ProjectionList()
    .Add(Projections.Property("id"), "id")
    .Add(Projections.Property("name"), "name")
));

Answer 2

ICriteria criteria = session.CreateCriteria(typeof(Person)); criteria.SetProjection( Projections.Distinct(Projections.ProjectionList() .Add(Projections.Alias(Projections.Property("FirstName"), "FirstName")) .Add(Projections.Alias(Projections.Property("LastName"), "LastName"))));

criteria.SetResultTransformer( new NHibernate.Transform.AliasToBeanResultTransformer(typeof(Person)));

IList people = criteria.List();