MTS and transactions

[msdnexpert]

Dear all,
How different is the transaction environment of MTS from those provided by databases such as Oracle and SQL-Server. I would like to know why and when one should use MTS. Thanks in advance.

[André]

Hi there, here is something to get you started:

MTS is much more than a transaction monitor.
You might need to do an action that involves multiple read writes to the database as well as calculations. This action should commit if it succeeds or abort if a part of the action fails. This is done by MTS.
Two-face commit is also a feature of MTS.

MTS gives you connection pooling, hence you will reuse open connections to the database.

MTS in win2000 is called COM+, and here you can also do object pooling.

MTS is the middle tier environment that will help your site to be scalable. YOu just have to remember to program stateless. No session variables!

I hope this braindump helps a little bit.

André

[msdnexpert]

Thanx Andre