TransactionScope()

Is discountAsp.net hosting support for TransactionScope() ?

 

So how can we handle Transaction Scope ?

 

Use System.Data.SqlClient.SqlTransaction. If that's not what you're after, explain what you're trying to do and someone might be able to help.

 

I have web application hosted in Discount asp.net Its use NHibernate for Data access .Now I need to handle Transaction Scope so I decide to use to ADO.net Transaction Scope but the Discount asp.net not support that so ,I'm looking for any other suggestion

 

NHibernate supports both (1) MSDTC System.EnterpriseServices transactions and (2) ADO.NET transactions. Bruce has advised that MSDTC is not supported so that leaves you with option 2. Whether this works for you now depends on your requirements and actual NHibernate code and since NHibernate requires some extra code (but not much) for MSDTC support, it's actually easier to implement option 2 anyway. Typical code would look like:

using( ISession session = sessions.OpenSession() )
using( session.BeginTransaction() ) {
//do some data operation e.g. CreateMyNewRows();
session.Transaction.Commit();
}

Actual use of the underlying ADO.NET transaction plumbing architecture is abstracted away by the NHibernate framework and the configured provider in use.

Personally I've not tried it, but I'm confident this will work on DASP as long you're using an NHibernate SQL Server session since NHibernate will be using System.Data.SqlClient transactions at a lower level.

 

...Nicely done Joe. ;-)

 

Thank you very much your advice .I 'll try this