How to pass a parameter to hbm file in Nhibernate

See more:

NHibernate

Hi Everyone,

I am new to Nhibernate. i want to pass a parameter to .hbm file without using createcriteria() method here is my hbm file.

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" assembly="MyAssembly" namespace="MyAssembly">
  <class name="Product" table="Product">
    <id name="Id" column="id">
      <generator class="native" />
    </id>
    <property name="Created" column="Created" not-null="true" />
    <property name="ProductName"  formula="(select top 1 p.productname from product p where p.productname='i want to pass a parameter here as dynamic')"/>
    <property name="IsActive" column="IsActive" not-null="true" />
  </class>
</hibernate-mapping>

As mentioned above product name has to pass dynamic.

Kindly help me anyone, how to do it.

Thankyou,