Thanks again for your answer! But actually I don't know how this could help in my special case. There's nothing in the documentation about it and I've got no sample how to use it with my stored procedure which contains an out- parameter... :/
Any sample link for me? Thanks Fred On 30 Mrz., 16:11, Fabio Maulo <[email protected]> wrote: > Do you know IQuery.ExecuteUpdate() ? > > 2009/3/30 Fred F. <[email protected]> > > > > > > > > > Hi, > > > I'm currently trying to execute a stored procedure through the > > nhibernate session. I've read in the best practises chapter that I > > shouldn't manage the additional database sessions by myself, but shall > > use the nhibernate session. So I did and I've created the code below. > > Sad but true: For each call of my stored procedure a new database > > session is opened, but won't be closed again although I do explicitly > > try to close and dispose them. > > > Any hints for me? > > Thanks in advance. > > > NHibernate Version 2.0.1 > > > Fred F. > > > ----------------------------------------------------------------------------------- > > [code] > > > Dim toReturn As New MyKeyType > > > Try > > > Using prov As IConnectionProvider = > > ConnectionProviderFactory.NewConnectionProvider > > (_configuration.Properties) > > > Dim conn As IDbConnection = prov.GetConnection() > > Dim cmd As IDbCommand = conn.CreateCommand() > > > cmd.Transaction = conn.BeginTransaction() > > > cmd.CommandText = "mypackage.mystoredproc" > > cmd.CommandType = CommandType.StoredProcedure > > > '-- param 1 > > Dim param1 As OracleParameter = New OracleParameter > > ("param1", OracleType.VarChar) > > param1.Value = "testparam" > > cmd.Parameters.Add(param1) > > > '-- param 2 (out parameter) > > Dim outParam As OracleParameter = New OracleParameter > > ("returnparam", OracleType.Cursor) > > outParam.Direction = ParameterDirection.Output > > cmd.Parameters.Add(outParam) > > > cmd.ExecuteNonQuery() > > cmd.Transaction.Commit() > > > Dim reader As OracleDataReader = CType > > (cmd.ExecuteReader(), OracleDataReader) > > If Not reader.HasRows Then > > Throw New Exception("Error") > > End If > > > reader.Read() > > > '-- parse some data from the reader to the return value > > toReturn.Key1 = Parse(reader, 0) > > toReturn.Key2 = Parse(reader, 1) > > > cmd.Dispose() > > conn.Close() > > prov.CloseConnection(conn) > > > End Using > > > Catch ex As Exception > > Throw New Exception("Error", strTypeName), ex) > > End Try > > > [/code] > > -- > Fabio Maulo- Zitierten Text ausblenden - > > - Zitierten Text anzeigen - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
