Guys,
Anyone can help me...
How to create create query with the use of HQL parameters in
Nhibernate 2.0.1. I am newbie in using NHibernate...
Please see my code below.
--CLASS--
namespace HOGPManPower.DomainModel
{
public class MAgency
{
private string m_oid;
private string m_agencyname;
private string m_description;
private string m_statusflag;
private DateTime m_lastupdate;
private string m_updateby;
public MAgency()
{
}
public virtual string oid
{
get { return m_oid; }
set { m_oid = value; }
}
public virtual string agencyname
{
get { return m_agencyname; }
set { m_agencyname = value; }
}
public virtual string description
{
get { return m_description; }
set { m_description = value; }
}
public virtual string statusflag
{
get { return m_statusflag; }
set { m_statusflag = value; }
}
public virtual DateTime lastupdate
{
get { return m_lastupdate; }
set { m_lastupdate = value; }
}
public virtual string updateby
{
get { return m_updateby; }
set { m_updateby = value; }
}
}
--TABLE MAPPING---
?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<!--namespace="HOGPManPower.DomainModel"
assembly="HOGPManPower.DomainModel"
schema="HRDBA" >-->
<class name="HOGPManPower.DomainModel.MAgency,
HOGPManPower.DomainModel" table="MAgency" lazy="true">
<id name="oid" column="OID" type="String" length="36">
<!--<column name="OID" type="String" length="36">-->
<generator class="uuid.hex" />
</id>
<property name="agencyname" type="String" length="50"></property>
<property name="description"></property>
<property name="statusflag"></property>
<property name="lastupdate"></property>
<property name="updateby"></property>
</class>
</hibernate-mapping>
--hibernate.cfg.xml--
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="hibernate-configuration"
type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
<!--<section name="log4net"
type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />-->
</configSections>
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property
name="connection.provider">NHibernate.Connection.DriverConnectionProvider,
NHibernate</property>
<!-- This is the Oracle.Client.dll provider for ORACLE Server --
>
<property
name="connection.driver_class">NHibernate.Driver.OracleClientDriver</
property>
<!--HRDBAPPS Server-->
<property name="connection.connection_string">
Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=172.17.3.77)(PORT=1521)))(CONNECT_DATA=(SERVER=SHARED)
(SERVICE_NAME=HRDBAPPS)));User ID=HRDBA;Password=hrdba
</property>
<property name='prepare_sql'>true</property>
<property name="show_sql">true</property>
<property name="dialect">NHibernate.Dialect.OracleDialect</
property>
<mapping assembly="HOGPManPower.DomainModel"/>
</session-factory>
</hibernate-configuration>
This is my query---
public override void Load()
{
ISession session = sessionFactory.OpenSession();
Object obj = "1";
try
{
string query = "from MAgency ma where
ma.statusflag= :ma.statusflag";
IList<MAgency> magency = session.CreateQuery
(query).SetString("ma.statusflag", "1")
.List<MAgency>();
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex.InnerException);
}
finally
{
session.Close();
}
}
public override bool Insert(object obj)
{
Boolean ret = false;
if (obj is MAgency)
{
MAgency objToSave = (MAgency)obj;
ISession session = sessions.OpenSession();
ITransaction transact = session.BeginTransaction();
try
{
objToSave.lastupdate = CFunctionUtils.getServerDate
();
session.Save(objToSave);
transact.Commit();
ret = true;
}
catch (Exception ex)
{
transact.Rollback();
throw new Exception(ex.Message,
ex.InnerException);
}
finally
{
session.Close();
}
}
return ret;
}
There is no error in Nhibernate but there is no result count that
get. The Entity count is 0?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
