Transactions ADO.NET and ADO

[Shawn B.]

Greetings,

Not sure if this is the right newsgroup, and not sure which would be the
best NG for this question.


I currently have a DAL that wraps and simplifies ADO.NET (similar but more
featuresome than the ApplicationBlock example from MS). It supports
transaction sharing between multiple instances of the DAL.

I'm going to create a class that extends it and provides a way to return ADO
recordsets. The DAL, BTW, has a plugin interface so we can write plugins
that capture debugging and diagnostic information if we need (and debugging
has greatly been simplified as a result of it) to otherwise plugins are
ignored and not loaded (an XML file holds the settings and switches).
That's why I need to inherit and extend this class (unless I want to write a
second set of plugins or at least, a second interface and COM interop
everything (yuck)). The DAL is already used in production and very well
supports 1000's of requests per minute (even with plugins enabled) so
performance isn't an issue.


Here's my question: I know I can't use an ADO.NET Transaction with ADO, but
is there way it can be achieved? Say, COM+? Where can I find info about
implementing such distributed transactions?


Thanks,
Shawn

 

[=?iso-8859-1?Q?Fredrik_Norm=E9n_NSQUARED?=]

I should recommand you to use Enterprise Services (COM+)
when you want to share transactions between objects.

Try to keep transactions as short as possible. This will
help minimize lock contention and increase throughput

Here is an Article about Enterprise Services:

COM+ Integration: How .NET Enterprise Services Can Help
You Build Distributed Applications

http://msdn.microsoft.com/msdnmag/issues/01/10/complus/

/Fredrik Normén NSQUARED2