Book Image

Hands-On Object-Oriented Programming with C#

By : Raihan Taher
Book Image

Hands-On Object-Oriented Programming with C#

By: Raihan Taher

Overview of this book

Object-oriented programming (OOP) is a programming paradigm organized around objects rather than actions, and data rather than logic. With the latest release of C#, you can look forward to new additions that improve object-oriented programming. This book will get you up to speed with OOP in C# in an engaging and interactive way. The book starts off by introducing you to C# language essentials and explaining OOP concepts through simple programs. You will then go on to learn how to use classes, interfacesm and properties to write pure OOP code in your applications. You will broaden your understanding of OOP further as you delve into some of the advanced features of the language, such as using events, delegates, and generics. Next, you will learn the secrets of writing good code by following design patterns and design principles. You'll also understand problem statements with their solutions and learn how to work with databases with the help of ADO.NET. Further on, you'll discover a chapter dedicated to the Git version control system. As you approach the conclusion, you'll be able to work through OOP-specific interview questions and understand how to tackle them. By the end of this book, you will have a good understanding of OOP with C# and be able to take your skills to the next level.
Table of Contents (16 chapters)

Transactions in SQL

A transaction is a single unit of work that either has to complete the whole work or roll back to its previous state. A transaction can't stop in the middle of a piece of work. It's a very important feature for sensitive data-handling. One of the best uses of transactions is when dealing with money-transfer processes. When a person transfers some money to another person's account, if any error occurs in the middle of the process, the whole process should be cancelled or rolled back.

There are four properties of a transaction in SQL: Atomic, Consistent, Isolated, and Durable (ACID).

Atomic

Atomic means that all statements in a group must be executed. If one of the statements in a group doesn...