How to use Stored Procedure using "nhibernate.Net". Please send exapmle.

I am using this way:-

1. On DefaultPage.aspx


protected void btnInsert_Click(object sender, EventArgs e)
{
Configuration cfg = new Configuration().Configure() ;
cfg.AddAssembly("NewNhibernate");
ISessionFactory factory = cfg.BuildSessionFactory();
ISession session = factory.OpenSession();
ITransaction tx = session.BeginTransaction();
IList products = session.GetNamedQuery("nhibernate").List();
TextBox1.Text = products.ToString();
//TextBox1.Text = q.SetFirstResult(1).ToString();
//TextBox1.Text = p1.Name;
tx.Commit();
}

2. Product.hbm.xml


<?xml version="1.0" encoding="utf-8" ?>
<sql-query name="nhibernate" callable="true">
<return class="Product">
<!--the name refers to the mapped property, and the column is the returned value from the database call-->
<return-property name="Id" column="id" />
<return-property name="Name" column="name" />
<return-property name="Sex" column="sex" />
<return-property name="Weight" column="weight" />

</return>
<!-- write any native SQL needed here, as NHibernate will send this to the database verbatim -->
exec [nhibernate]
</sql-query>


3. I have made all changes in web.config and mapping file.

4. Get this error "Named query not known: nhibernate".

Please Help.

Deepak

You could try http://www.rmfusion.com. There are some useful code examples on NHibernate.NET under the Open Source section.

Have you set Build Action of Product.hbm.xml to Embedded Resource ?