Basic .NET path | Useful Links

OOP Fundamentals and Design Principles

This module will guide you through the four basic OOP concepts like abstraction, encapsulation, inheritance, and polymorphism. You will also become familiar with the key OOP design principles like SOLID, GRASP, and more general principles like DRY, KISS and YAGNI. The module also requires you to design and implement a simple application to get practical experience in applying these principles.

Self Study materials


Chapter 1 only - Object Oriented Fundamentals

Object-Oriented programming (C#) - Microsoft article

Inheritance in C# and .NET - Microsoft article

Overview of classes, structs, and records in C# - microsoft article


S.O.L.I.D, GRASP and Other Basic Principles of Object-Oriented Design - an article

S.O.L.I.D. Principles of Object-Oriented Programming in C# - an article

DRY, KISS & YAGNI Principles - an article


The goal of this module is to provide an overview of Language-Integrated Query (LINQ) and its operations like filtering and aggregation. You will learn the essential parts of a query operation and how to use extension method along with query expression syntax. At the end of the module, you will apply the acquired knowledge in composing queries for Orders, Products and Customers data models.

LINQ Introduction - Microsoft article

LINQ to Objects - Microsoft article

Learn the basics of working with Language-Integrated Query (LINQ), which allows developers to filter, sort, aggregate, and query data directly within C# code.

10 LINQ Myths - an article

ADO.NET Fundamentals

The goal of this module is to provide an overview of ADO.NET technology, connected and disconnected models. Practical task includes implementation of the DAL (Data Access Layer) using ADO.NET for database access.

ADO.NET - Microsoft article

ADO.NET Overview (whole section) - Microsoft article

Securing ADO.NET applications (whole section) - Microsoft article

Connection to a Data Source (whole section) - Microsoft article

Connection Strings in ADO.NET (whole section) - Microsoft article

Commands and Parameters (whole section) - Microsoft article

DataAdapters and DataReaders (whole section) - Microsoft article

Modifying Data with Stored Procedures - Microsoft article

Basics of ADO.NET - an article

Microsoft ADO.NET for SQL Server (whole section) - Microsoft article

Connected vs Disconnected Architecture in C# - an article