Webcast: Building your own block with Enterprise Library for .NET 2.0

Using TransactionScope with the Data Access Application Block

John Yung — Fri, 10 Feb 2006 03:24:25 GMT

Hi,

I am using TransactionScope and Data Access Block 2.0 to manage distributed transactions. The following is my code:

using (TransactionScope transScope = new TransactionScope()) {

using (DbConnection conn_saccorpaction = _dbsaccorpaction.CreateConnection()) {

conn_saccorpaction.Open();
try {
_dbsaccorpaction.ExecuteNonQuery(CommandType.Text, "exec sacprg.p_SACt_Insert " + txtPKey.Text);
} catch {
return;
}

using (DbConnection conn_sacdetails = _dbsacdetails.CreateConnection()) {

conn_sacdetails.Open();
try {
_dbsacdetails.ExecuteNonQuery(CommandType.Text, "exec sacprg.p_SACt_Insert " + txtPKey.Text);
} catch {
return;
}
}

}

transScope.Complete(); // The Complete method commits the transaction.

}

My concern is since I am not explicitly setting the connection object to be use to execute all those SQL commands, is it possible for _dbsaccorpaction or _dbsacdetails to use another connection to execute those SQL commands?

What happens if another thread is using the same database object to execute other SQL commands?

Thanks,

John Yung

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

Ravi K Pasumarthy — Tue, 14 Feb 2006 01:37:51 GMT

Hi,

Currently i'm using VistaDB (embedded database) and its .net data provider in my project. And in the future we may be moving to sql server, now i have to write data access layer that is not dependent on the database, so i have choosen to use enterprise DAAB, but i dont know how to customize (pluging my vistadb classes) into enterprise library so that if i code this way database.createdatabase() will return vistadatabase. If you have any sample codes or articles that can explain the above scenario. It will be helpful for me.

Thanks and Regards,
Ravi K Pasumarthy,
CCH, a Wolters Kluwer business,
Ravi_Kumar@cch.com

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

Jonathan George — Wed, 15 Feb 2006 11:28:57 GMT

Hi, The link to the web cast doesn't appear to be correct - it points to a web cast on the configuration block. Any chance of fixing it, as I'd very much like to get hold of the presentation.

Thanks,
Jon

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

tomholl — Wed, 15 Feb 2006 20:42:40 GMT

Hi Jon -

The link is correct but the title on the webcast site is wrong. I'll see if we can get this fixed.

thanks
Tom

Data Access Application Block Faq

Harjeet — Thu, 16 Feb 2006 14:35:49 GMT

Hi,

Anybody knows "How to set command timeout while using 'Data Access Application Block' " ?

Please try to reply to harjeet.bhatia@opussoft.com

Thanks & Regards,

- Harjeet

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

Sid D H Arthur — Tue, 21 Feb 2006 18:06:05 GMT

Slightly off-topic I know, but I would like to know if there are a performance degradation when using the Application Blocks? In particular, I'm thinking if there is a performance hit when Instrumentation (perfmon) is turned on for an application that is using the EAB2.

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

Khuzema — Wed, 08 Mar 2006 11:36:22 GMT

Hi,
Is there any plan to update User Interface Process Application Block for Framework 2.0 and/or a reference application which includes both UIP and EntLib 2.0.

If this is not right place for this info can you kindly point to site/community where i can send my comments.

thanks & regards

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

Ramil — Thu, 09 Mar 2006 10:42:44 GMT

Hi,

Is there a VB.NET version of this example code on how to create your own application block using Enterprise Library 2.0 January 2006?

TIA.

re: Webcast: Building your own block with Enterprise Library for .NET 2.0

tomholl — Thu, 09 Mar 2006 22:22:25 GMT

Sorry all for the slow responses - I'll explain why in my next post :-)

Sid: The performance profile of the EntLib v2 blocks is slightly different from the v1 blocks, mainly due to the change of configuration system and the introduction to ObjectBuilder. The "initial hit" to all blocks should now be much faster than in v1. The performance of subsequent calls varies depending on the block and configuration - although most blocks are slightly slower with instrumentation enabled but quicker with it disabled. Logging is quicker across the board. As always, you should run tests that reflect your environment and requirements to see if the blocks meet your performance goals.

Khuzema: There are plans to update UIP - I know we've been saying that for a while but it's still in the plans. The owner of this is now Eugenio Pace (http://blogs.msdn.com/eugeniop) so look out for details on his blog.

Ramil: Sorry, not at this time. However the concepts demonstrated all apply to VB.NET as well as C#.

Tom