Hi,

In our proejct we have the main part that is doen by NHibernate, but a small part of the information is selected by an other dll, which doesn't use NHibernate but simpel SqlDataAdapters.

This works, but not in every situation. When I have a SqlDataAdapter-Select inbetween an NHibenrate Transaction, I get this Timeout-exception. which is totally logical because NHibernate locks these tables.


The possbile solutions I see:
- putting the external dll on NH (but can't be done now)
- specifying another lock-type for NH so 'outside' selects o nthe same tables will be able during an NH-transaction. BUT: HOW?
- giving the external dll the same connection and putting it in the same transaction as NH uses. BUT: HOW?


Any help woudl be really appreciated...


Thansk a lot in advance,


Pieter


Hibernate version: 1.2

If you can get at the underlying SqlCommand in the SqlDataAdapter, you should be able to enlist it into the ITransaction.

And how should I do this exactly?

Ok I found it already here: http://www.lostechies.com/blogs/joshua_lockwood/archive/2007/04/10/how-to-enlist-ado-commands-into-an-nhibernate-transaction.aspx

This is really a great feature!! Thanks a lot in advance! :-)