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.

Related Content you might be interested in

Current Title:

Small book image
Hands-On Object-Oriented Programming with C#
Raihan Taher
Feb, 2019 | 288 pages
Small book image
Learn C# Programming
Raffaele Rialdi | Ankit Sharma | Marius Bancila
Apr, 2020 | 636 pages
Small book image
Programming in C#: Exam 70-483 (MCSD) Guide
SrinivasMadhav Gorthi | Simaranjit Singh Bhalla
Oct, 2019 | 444 pages
Small book image
Learn C# in 7 days
Gaurav Aroraa
Oct, 2017 | 306 pages
Table of Contents (16 chapters)
Preface
Preface
Who this book is for
What this book covers
To get the most out of this book
Get in touch
Free Chapter
1
Overview of C# as a Language
Overview of C# as a Language
Evolution of C#
Architecture of .NET
Fundamentals and syntax of C# language
Writing your first C# program in a console application
Visual Studio as an editor
Writing your first program in Visual Studio
Summary
2
Hello OOP - Classes and Objects
Hello OOP - Classes and Objects
Classes in OOP
Objects in OOP
Variables in C#
Methods in a class
Characteristics of OOP
Summary
3
Implementation of OOP in C#
Implementation of OOP in C#
Interfaces
The abstract class
The partial class
The sealed class
Tuples
Properties
Access specifiers for classes
Summary
4
Object Collaboration
Object Collaboration
Examples of object collaboration
Different types of object collaboration in C#
Summary
5
Exception Handling
Exception Handling
Why we need exception handling in programming
Basics of exception handling
Try and catch
What happens if you don't handle exceptions?
Multiple catch blocks
Using the throw keyword
What does the finally block do?
Exception class
User-defined exceptions
The exception filter
Exception handling best practices
Summary
6
Events and Delegates
Events and Delegates
What is a delegate?
Method group conversion
Multicasting
Covariance and contravariance
Events
Summary
7
Generics in C#
Generics in C#
What are generics?
Why do we need generics?
Different constraints of generics
Generic methods
Covariance and contravariance in generics
Summary
8
Modeling and Designing Software
Modeling and Designing Software
The importance of design diagrams
Class diagrams
Use case diagrams
A sequence diagram
Summary
9
Visual Studio and Associated Tools
Visual Studio and Associated Tools
Visual Studio project types and templates
Visual Studio Editor and different windows
Debugging windows
Breakpoints, Call Stack Trace, and Watch
Git in Visual Studio
Refactoring and code-optimization techniques
Summary
10
Exploring ADO.NET with Examples
Exploring ADO.NET with Examples
The fundamentals of ADO.NET
Connecting to various databases
Working with DataReaders and DataAdapters
Working with stored procedures
Working with the Entity Framework
Transactions in SQL
Summary
11
New Features in C# 8
New Features in C# 8
Environment Setup
Nullable reference types
Async streams
Ranges and indices
Default implementation of interface members
Switch expressions
Target-typed new expressions
Summary
12
Understanding Design Patterns and Principles
Understanding Design Patterns and Principles
Design principles
Creational design patterns
Structural design patterns
Behavioral design patterns
The MVC pattern
Summary
13
Git - The Version Control System
Git - The Version Control System
What is version control?
How Git works
Installing Git on Windows
The basics of Git
Branching in Git
Summary
14
Prepare Yourself - Interviews and the Future
Prepare Yourself - Interviews and the Future
Interview questions
Interview and career tips
Things to learn next
Building the habit of reading
Summary
15
Other Books You May Enjoy
Other Books You May Enjoy
Leave a review - let other readers know what you think

Working with stored procedures

Stored Procedures are batches of SQL statements that are stored in a database for the purpose of reuse. ADO.NET has support for Stored Procedures, which means that we can use ADO.NET to call stored procedures in a database and get results from them. It is a very common practice to pass parameters, which could be input or output parameters, to stored procedures. The ADO.NET command object has parameters that are objects of the parameter type. Depending on the provider, the parameter object changes, but they all follow the same base. Let's take a look at how to use stored procedures instead of normal SQL statements in ADO.NET.

To use a stored procedure, the SQL string that is passed in SQLCommand should be the name of the Stored Procedure:

string ConnectionString = "Integrated Security = SSPI;Initial Catalog=Northwind;Data source=localhost...
Previous Section
End of Section 5
Next Section