在 Nhibernate 中为命名参数赋值的问题

发布于 2024-12-17 16:27:45 字数 1249 浏览 1 评论 0原文

我对 Nhibernate 比较陌生。我正在尝试更新存储过程。我在命名查询中得到了以下部分。

<sql-query name="TestUpdate">
exec UpdateTest :DateField :StringField :IntField :BoolField :NullIntField
</sql-query>

Testupdate 是一个存储过程，其中有一个简单的更新语句。我正在使用以下代码行更新参数。

        int? testdata = null;
        IQuery query = Session.GetNamedQuery("TestUpdate");
        query.SetDateTime("DateField", DateTime.Now.AddDays(10));
        query.SetString("StringField", "UK");
        query.SetInt32("IntField", 100);
        query.SetBoolean("BoolField", true);

        if(testdata.HasValue)
            query.SetInt32("NullIntField", testdata.GetValueOrDefault());
        else
        {
            query.SetParameter("NullIntField", null,NHibernateUtil.Int32);    
        }

        var cmd  = new SqlCommand(query.QueryString, (SqlConnection)Session.Connection);
        cmd.ExecuteNonQuery();

但是，当我查看 query.QueryString 的值时，它仍然指向相同的值（exec UpdateTest :DateField :StringField :IntField :BoolField :NullIntField）。似乎命名参数没有被分配。我应该怎么做才能解决这个问题？

我正在使用 SharpArchitecutre，它使用流畅的 nhibernate 来查询数据。

请注意，我已经在论坛中搜索了这个特定问题，但找不到示例。

我确信这个问题可能是微不足道的，但到目前为止我找不到解决方案。

任何帮助表示赞赏。

原文

I am relatively new to Nhibernate. I am trying to update a stored procedure.
I got the below section in the named query.

<sql-query name="TestUpdate">
exec UpdateTest :DateField :StringField :IntField :BoolField :NullIntField
</sql-query>

Testupdate is a stored procedure which will has a simple update statement in it. I am updating the parameters using the following line of code.

        int? testdata = null;
        IQuery query = Session.GetNamedQuery("TestUpdate");
        query.SetDateTime("DateField", DateTime.Now.AddDays(10));
        query.SetString("StringField", "UK");
        query.SetInt32("IntField", 100);
        query.SetBoolean("BoolField", true);

        if(testdata.HasValue)
            query.SetInt32("NullIntField", testdata.GetValueOrDefault());
        else
        {
            query.SetParameter("NullIntField", null,NHibernateUtil.Int32);    
        }

        var cmd  = new SqlCommand(query.QueryString, (SqlConnection)Session.Connection);
        cmd.ExecuteNonQuery();

However, when I look at the value of query.QueryString, it still points to the same value (exec UpdateTest :DateField :StringField :IntField :BoolField :NullIntField). It seems like the named parameters are not getting assigned. What should I do to get around this problem?

I am using SharpArchitecutre, which uses fluent nhibernate to query the data.

Please note, I have searched the forum for this particular issue and I couldn't land on an example.

I am sure the issue could be trivial, but I couldn't find a solution so far.

Any help is appreciated.

分享到QQ

分享到微博