Transaction support while using Microsoft.ApplicationBlocks.Data - Extend It! ( Programming in VS2005 & 2008, ASP.Net 2.0 )

Forum General DotNetN... Extend It! ( Pr... Transaction support while using Microsoft.ApplicationBlocks.Data

5/4/2008 7:57 AM

	r_honey
118 posts

Transaction support while using Microsoft.ApplicationBlocks.Data

I am creating Data Provider for my module for Sql Server 2005. Some actions require multiple updations to be made to the database. All the magic happens inside a Stored Procedure for each such action. The procedure performs all the updations in one go. I want these updations to succeed or fail together.

They are called through SqlHelper class from the DataProvider. My question is whether SqlHelper methods initiate a transaction before calling the procedure, or transactions have to be handled through the procedure itself???

Also, I would like to know whether SqlHelper opens & closes connections for each call to its methods or it pools the connections???

5/4/2008 3:19 PM

	cathal connolly
2638 posts
www.cathal.co.uk

Re: Transaction support while using Microsoft.ApplicationBlocks.Data

the version of the DAB we're using doesn't have a transactional overload, so you'll have to handle transactions within the proc's themselves. When you execute a query through the helper it automatically opens and closes the connection as necessary. By default sqlconnections are all pooled, so these open and closes do not have a large overhead as closing a connection simply deactivates it and leaves it in the pool, if a new connection with the same credentials is then received within a short time period then the connection is reactivated to be used - reactivating a connection is a much quicker operation than creating a new one.

Cathal

Page 1 of 1

Forum

General DotNetN...

Extend It! ( Pr...

Transaction support while using Microsoft.ApplicationBlocks.Data