NHibernate - 当 PK 列之一为 NULL 时，使用复合 PK 删除对象

发布于 2024-08-13 09:44:22 字数 744 浏览 10 评论 0原文

嘿，我正在尝试从 Oracle 10g 表中删除以下结构的实体：

class Record 
{
   string id;
   string name;
   DateTime dateTime;
}

使用以下映射：

<class name="Records" table="RECS">
   <composite-id>
      <key-property name="P_ID" />
      <key-property name="NAME" />
   </id>
   <property name="dateTime" column="DATE_TIME_V" />
</class>

现在，假设表的 PK 是 P_ID 和 NAME 列（复合键），当 NAME 允许空值但 P_ID 不允许时t。现在的问题是，当 NHibernate 尝试删除一个对象（比如 P_ID = 9 且 NAME = NULL）时，它会输出以下删除语句：

delete from RECS R where R.P_ID = 9 and NAME = NULL

显然，该操作不会删除任何内容，因为 'NAME = NULL' 应该是 'NAME IS无效的'。我是否在这里遗漏了一些导致 NHibernate 像对待任何其他值一样对待空值的东西？

谢谢，哈雷尔

原文

Hey, i'm trying to delete an entity of the following structure from an Oracle 10g tables:

class Record 
{
   string id;
   string name;
   DateTime dateTime;
}

with the following mapping:

<class name="Records" table="RECS">
   <composite-id>
      <key-property name="P_ID" />
      <key-property name="NAME" />
   </id>
   <property name="dateTime" column="DATE_TIME_V" />
</class>

Now, say that the table's PK is P_ID and NAME columns (composite key), when NAME allow nulls but P_ID doesn't.
Now, the issue is that when NHibernate tries to delete an object with, say, P_ID = 9 and NAME = NULL, it outputs the following delete statement:

delete from RECS R where R.P_ID = 9 and NAME = NULL

Obvioisly, the operation will delete nothing since 'NAME = NULL' should be 'NAME IS NULL'.
Am i'm missing something here that causes NHibernate to treat nulls like any other values?

Thanks,
Harel

分享到QQ

分享到微博