I am currently doing a project utilizing NHibernate to connect to a legacy Oracle DB. Everything was nice and easy until I hit this problem. I need to retrieve a particular information, but to do this I must connect a number of tables. This means I need to create more persistent classes, more mapping files, which is sucks because I can actually just execute a stored function and get what I need.

So after scratching my head for quite sometimes, I found out that the solution was quite simple.

Using sessFact As ISessionFactory = CreateSessionFactory()
   Using sess As ISession = sessFact.OpenSession()
      Using transact As ITransaction = sess.BeginTransaction()
         '....
         Dim con As IDbConnection = sess.Connection
         Dim cmd As IDbCommand = con.CreateCommand()
         sess.Transaction.Enlist(cmd)
         cmd.CommandText = "select MyPackageName.MyFunction(" & myFunctionParam & ") from dual"
         dim objResult as Objetc = cmd.ExecuteScalar()
         '.....
      End Using
   End Using
End Using

I know this is not the right way, but I need to make compromise considering that this is a legacy database.

 

Possibly Related Posts

• How to Connect TOra to Oracle Database
• Oracle + IIS + ASP.NET Problem: Oracle client and networking components were not found
• Oracle + IIS + ASP.NET Problem: RESOLVED

 

nhibernate oracle function (10), nhibernate logo (4), nhibernate call function (2), how to use nhibernate to call function oracle (2), call oracle function from nhibernate (1), nhibernate execute oracle function (1), nhibernate execute oracle functions (1), nhibernate oracle (1), nhibernate oracle call function (1), nhibernate oracle call package function (1), nhibernate oracle functions (1), nhibernate oracle sysdate function (1), oracle function from nhibernate (1), oracle function mapping nhibernate (1), oracle function nhibernate (1), nhibernate charp stored function oracle (1), nhibernate call oracle function (1), nhibernate call or execute oracle (1), calling oracçe function nhibernate net (1), calling package Nhibernate (1), execute function nhibernate (1), executing oracle function with nhibernate (1), function with nhibernate (1), functions in nhibernate in oracle (1), functions nhibernate (1), how do i call oracle function with nhibernate in c# (1), how to exec function in oracle (1), net execute oracle function return (1), nhibernate (1), nhibernate - call richiamare una function oracle (1)

Advertise Here