Hibernate version: 1.2.0

in 1.0.2.0 i used this execute procedures:
ISessionFactoryImplementor sfi = (ISessionFactoryImplementor)EntityDB.Factory;
IDbCommand dbCmd = sfi.ConnectionProvider.Driver.CreateCommand();
dbCmd.CommandText = spName;
dbCmd.CommandType = CommandType.StoredProcedure;

but in 1.2.0 IDriver have not CreateCommand() method, i will how to execute procedure.

thanks!

Use ISession.Connection.CreateCommand. Or use methods of sfi.ConnectinoProvider. IDriver is a semi-internal interface (as well as ISessionFactoryImplementor, by the way) and it wasn't supposed to be used from outside NHibernate.

Thanks for you reply.

i can use session.CreateSQLQuery("Select sysdate from dual").AddScalar("sysdate", NHibernateUtil.DateTime).List(),get the Oracle sysdate, I don't know if i want to execute proc used this,how can i do.

thanks!