Understanding Transactions and Creating Transaction Enabled WCF Services.
When we talk about transactions in database operations, we need to perform some operation(database operations) in such a way that either all the operations are successful or all of them fail. This would result in the amount information being same once the transaction is successful or it fails. Properties of Transaction By definition a transaction must be Atomic, Consistent, Isolated and Durable. What does we mean by all these terms Atomic : Atomic means that all the statements (SQL statement or operations) that are a part of the transaction should work as atomic operation i.e. either all are successful or all should fail. Consistent : This means that in case the atomic transaction success, the database should be in a state that reflect changes. If the transaction fails then database should be exactly like it was when the transaction started. Isolated : If more than one transactions are in process then each of these transactions should work independently and should not effect...