如何从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的局限性，来自

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屋！