Is there some way to specify "where" dynamically on a map?

Question

Lets consider the following simplified mapping:

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"  assembly="xxx" namespace="yyy">
  <class name="Customer" table="Customers">
    <id name="Id" column="customerID" type="Int64">
      <generator class="native"/>
    </id>

    <!-- LOOK AT THE WHERE BELOW .-->
    <map where="codeType='BO'" name="Conversions" table="CustomersCodes" >
      <key column="customerID"></key>
      <index   column="codeType" type="AnsiString"/>
      <element column="code" type="AnsiString"/>
    </map>

  </class>
</hibernate-mapping>

I would like to dinamycally specify the where ( that is sticked in the mapping in the sample ) in code, is it possible ?

As a viable alternative, is it possible to fetch just a key of the map with QueryOver or LinqToNH ? I did try with link to NH but it complain that the map does not contain an entity ( true, since it is a map of elements, that is perfectly valid in NH and useful to optimize the speed in many cases )

score 1 · Answer 1 · answered Nov 04 '11 at 12:27

1

Perhaps NHibernate Filters could help you here Contextual data using NHibernate filters

answered Nov 04 '11 at 12:27

Mark Perry

1,705
10
12

+1 because it probably works, but looking for something I can use without interceptors... – Felice Pollano Nov 04 '11 at 13:42

Is there some way to specify "where" dynamically on a map?

1 Answers1