Transaction Query

From: Jude_44 (Jude_44_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 06:51:02 -0700

Hi There

I have been trying to establish how Transactions work from a .NET component.
Basically, I have an operation I want to work in a transactional manner, but I would like to control this from within a function.
How does Enterprise Services relate to COM+? Can I use Enterprise Services on a system without it having COM+ set up and my component installed there?

So basically I need to something like the following within a method:

Start a Transaction
Perform a number of ADO calls to my SQL Server DB, with numerous connection objects and many changes to DB records. If theres a problem I want it to roll back all DB changes.
End Transaction, and Commit if successful.

Do I need to put it all within a single StoredProcedure in order to get Transactional support, or is there a way I can do it from VB.NET using EnterpriseServices, without having to rely on COM+ being installed and component registered within same COM+?

Thanks for all your help!!

Regards
David Crone

Relevant Pages

  • Re: distributed transactions
    ... The most common set of problems not outlined here are machine configuration ... > This link is to the roadmap for Enterprise Services: ... >>in a single transaction to be able to rollback the all thing in any case ... >>The only problem is that the different sql statements are using 2 ...
    (microsoft.public.dotnet.framework.adonet)
  • question
    ... i use enterprise services for having transaction management. ... i use one transactional component that is creating an ado.net connection, ...
    (microsoft.public.dotnet.framework.adonet)
  • Transactions
    ... Class B. Class A inherits from enterprise services and has an attribute ... services and doesn’t have any transaction attribute specified. ... that also inserts another record in the database. ...
    (microsoft.public.dotnet.general)
  • Re: distributed transactions
    ... This link is to the roadmap for Enterprise Services: ... .NET application, and COM+ is the terminology used for older, ... >in a single transaction to be able to rollback the all thing in any case an ... hence 2 different SQL connections. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: transactions
    ... You can reach me thru my blog http://www.dotnetjunkies.com/weblog/sahilmalik ... > executeNonQuery (storedproc1, params) ... > commit transaction ... >> like on Enterprise Services is written by Juwal Lowy. ...
    (microsoft.public.dotnet.general)