Hello,

Lets say i have this class:

  public class Package
  {
    public virtual int Id { get; set; }
    public virtual PackageStatus Status { get; set; }
  }

and this mapping:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default-
lazy="true" assembly="InExchange.Domain"
namespace="InExchange.Domain">
  <class name="Package" table="ib_Package">
    <id name="Id" column="PackageId">
      <generator class="native"></generator>
    </id>
    <property name="Status" column="PackageStatusId"></property>
  </class>
</hibernate-mapping>

The key issue here is that the property names in the entity differ
from the column names in the table.

If I then enter this HQL: "from Package where Id = 2".

I would expect it to translate to this sql: "select ... from
ib_Package where PackageId = 2".

Unfortunaly it doesn't. Instead I get this sql: "select ... from
ib_Package where Id = 2".

It looks to me that the columns in the where clause is not processed
at all but are just passed through to an sql where clause. In fact, I
can enter any columnname I like and NH won't complain until I get an
SqlException.

Anyone else has this behavour?

Regards,
Johannes
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to