Database Reference
In-Depth Information
How It Works
By now, you should understand why both statements failed. This happened because the first statement
couldn't insert a duplicate record and the second statement couldn't delete a record that has associated
child records. This is why the Message pane in Figure 8-8 shows both the errors explicitly mentioning
duplicate keys and conflicting references with child records.
Summary
This chapter covered the fundamentals of transactions, including concepts such as understanding what
transactions are, ACID properties, local and distributed transactions, guidelines for writing efficient
transactions, and coding transactions in T-SQL. Although this chapter provided just the fundamentals of
transactions, you now know enough about coding transactions to handle basic transactional processing
and to implement it with later chapters using C# and ADO.NET.
In the next chapter, you'll learn about the fundamentals of Windows Forms.
