A part 2 to the original question..... I found that I could do the following:
IEventSource evtSrc = @event.Session; ISession session = evtSrc.GetSession(EntityMode.Poco); IDbConnection conn = session.Connection; ITransaction trans = session.Transaction; // The connection does not have an option to get the current transaction. I need this info so that I can do an SQL UPDATE via a command: IDbCommand cmd = conn.CreateCommand(); cmd.Transaction = trans; // THROWS AN EXCEPTION The problem I run into here is that the IDbCommand requires an IDbTransaction, not an ITransaction. I also cannot do the following: IDbTransaction trans = conn.BeginTransaction(); because I would be starting a transaction within a transaction, which is a no go. So, I guess my real question is whether I can run an SQL command to do an update during the OnPostInsert, which is called during an ongoing transaction. I am trying to do it this way because another project using a different O/R mapper is successfully doing it and it keeps me from doing sequential transactions which would then make a rollback difficult. Thoughts? -- 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.
