Hi All

The Example.Exclude property is unable to exclude all the properties from the search and has the effect of returning all rows from the table. See code snippet below. If I comment the For loop, then I can return the appropriate row(s) from the database

Thanks
-RV
Code snippet

public List<T> GetByExample(T exampleInstance, params string[] propertiesToExclude) {
ICriteria criteria = NHibernateSession.CreateCriteria(persitentType);
Example example = Example.Create(exampleInstance);

////////////Problem lines start
foreach (string propertyToExclude in propertiesToExclude)
{
example.ExcludeProperty(propertyToExclude);
}
//////////Problem lines end

criteria.Add(example);
return criteria.List<T>() as List<T>;
}





Mapping file
<hibernate-mapping default-cascade="none" xmlns="urn:nhibernate-mapping-2.2">
<class name="CompanyName.Project.AssemblyName.Domain.FQLocalClass, CompanyName.Project.AssemblyName" table="FQLocal" lazy="true">
<id name="ID" type="System.Int32" column="FQLocal_ID_D" unsaved-value="0">
<generator class="assigned" />
</id>
<property name="TagName" type="System.String" column="FQLocal_TAGNAME" not-null="true" length="100" />

</class>
</hibernate-mapping>

Sorry, not sure what you are trying to achieve here. If you exclude all the properties, you are effectively removing any restrictions on the rows, so you get all the rows, sounds logical to me.

Sergey, thanks for your response.

In my test scenario, I have unique value for both ID and TagName.
eg.

1, 'FirstTag'
2, 'SecondTag'
3, 'ThirdTag'
4, 'FourthTag'

And I have populated an example to search for using (1, 'FirstTag').
When I try to invoke GetByExample in the sample code without excluding any properties, I get the proper row count (1). When I try to exclude a property (either ID or TagName), I get back all 4 rows!


The Where statement is effectively doing Where (1=1)

THanks
-RV

Ok if this is indeed as you describe, please submit this as a bug, including a simple test case.