Irfan,
If you go for the stored procedure option, you can still have the
transaction span multiple tables. Its a matter of where you call the BEGIN
TRANS and END TRANS statements.
If you do not use COM+ for transactioning, then you can still use it for
everything else it provides. You just set the transaction mode to "Not
Supported"
I think that for what you are doing, you might want to go the stored
procedure route, or even the ADO.NET route. I don't think that COM+ is
terribly unperformant when providing transaction services, but it does
provide a flexibility that you don't seem to need (what if you have multiple
resources contributing in the transaction, for example?)
Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
-
mv*@spam.guard.caspershouse.com
"Irfan" <go*******@yahoo.com> wrote in message
news:e$**************@TK2MSFTNGP10.phx.gbl...
There are several ways of handling Transactions in DotNet. Some of them
are
1. Using COM+ Serviced Component.
2. Using ADO .Net
3. using stored procedure
What is the best way of handling Transaction in DotNet Enterprise
Application interms of performance, maintainance and scalability?
How feasible it would be if we go for stored procedure option, considering
our Transaction can span multiple tables?
can we still use other COM+ Services like object pooling etc if we go for
stored procedure option?
Regards,
Irfan