Visual Basic® .NET Power Coding

Using Transactions

The nature of a relational database is that the database designer tries to reconcile a reduction in redundancy and waste with an increase in complexity. This reconciliation is referred to in database jargon as normalization. The trade-off of normalization is the complexity introduced and the hoops we have to jump through to reassemble disparate tables into usable chunks. For example, from a programmer's perspective, orders and order details are related, but a reasonable database design would separate these pieces of information to avoid repeating order information for every detail item in the order. Then when the user wants to see a complete order, the order and detail information must be reassembled. Additionally, when operations ...