如何从 NHibernate 调用没有结果的存储过程? [英] How do I call a stored procedure from NHibernate that has no result?

问题描述

我有一个记录一些数据的存储过程，我如何用 NHibernate 调用它?

I have a stored procedure that logs some data, how can I call this with NHibernate?

到目前为止我有:

ISession session = ....
IQuery query = session.CreateQuery("exec LogData @Time=:time @Data=:data");
query.SetDateTime("time", time);
query.SetString("data", data);
query.?????;

????? 方法应该是什么?还是做错了更根本的事情?

What should the method ????? be? Or am doing something more fundamentally wrong?

推荐答案

这似乎是 NHibernate 的一个限制，来自 NHibernate 文档:

This seems to be a limitation of NHibernate, from NHibernate Documentation:

过程必须返回一个结果集.NHibernate 将使用 IDbCommand.ExecuteReader() 获取结果.

The procedure must return a result set. NHibernate will use IDbCommand.ExecuteReader() to obtain the results.

这篇关于如何从 NHibernate 调用没有结果的存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！