C# and .NET Application Development
Learn modern C# and .NET by building an online product store with classes, collections, LINQ, and Entity Framework Core.
Course overview
Build a practical foundation in C# and .NET during this four-day instructor-led course. Lectures and labs follow a single scenario: a company that sells products on its website, using the Microsoft Northwind sample database of products, categories, suppliers, customers, and orders. Start with the .NET SDK and C# basic types, model the store with classes and records, manage data with collections, query it with LINQ, and connect to Northwind with Entity Framework Core.
Course coverage
Progress from your first C# program to a database-backed product catalog for an online store.
- 01 .NET SDK, dotnet CLI, Visual Studio or VS Code, and projects
- 02 Basic types: int, decimal, string, bool, DateTime, and nullables
- 03 Decisions, switch expressions, pattern matching, and loops
- 04 Methods, parameters, return values, and exception handling
- 05 Classes, properties, constructors, records, and interfaces
- 06 Collections and generics: List, Dictionary, and HashSet
- 07 LINQ: filtering, projecting, sorting, grouping, and joining
- 08 Entity Framework Core: DbContext, entities, and Northwind scaffolding
- 09 EF Core queries, related data, updates, and async/await
- 10 A simple ASP.NET Core product catalog page
Participants will learn to
- Create, build, and run .NET projects with the dotnet CLI.
- Choose the right C# types, including decimal for prices.
- Control program flow with conditions, patterns, and loops.
- Model products, categories, and orders with classes and records.
- Store and look up data with generic collections.
- Query and summarize product and sales data with LINQ.
- Connect to Northwind and query it with Entity Framework Core.
- Add, update, and delete records and show products on a web page.
Four-day course outline
Day 1 - C# and .NET fundamentals: Install the .NET SDK, create console projects with the dotnet CLI and Visual Studio or VS Code, and understand solutions, projects, and NuGet packages. Work with int, decimal, double, string, bool, and DateTime, use var, string interpolation, and nullable reference types, and make decisions with if, switch expressions, and pattern matching. Lab: calculate product prices, discounts, and order totals for the store.
Day 2 - Classes and collections: Write methods and handle exceptions. Create classes with properties, constructors, and methods, use records for simple data, and apply inheritance and interfaces. Store data in arrays, List<T>, Dictionary<TKey,TValue>, and HashSet<T>. Lab: model Product, Category, Customer, and Order classes and manage an in-memory product list.
Day 3 - Querying data with LINQ: Use LINQ method and query syntax to filter with Where, shape results with Select, sort with OrderBy, group with GroupBy, join related data, and calculate Count, Sum, Average, Min, and Max. Understand lambda expressions and deferred execution. Lab: find low-stock products, best-selling categories, and customer order totals.
Day 4 - Entity Framework Core and the Northwind database: Scaffold a DbContext and entity classes from Northwind, configure connection strings, query with LINQ to Entities, load related data with Include, and add, update, and delete records with SaveChanges. Use async and await and review migrations. Final lab: display a searchable product catalog on a simple ASP.NET Core page.
Format and audience
For: New C# developers, programmers moving to .NET from other languages, analysts, and technical staff building business applications.
Prerequisites: Basic computer skills; some exposure to programming or SQL is helpful but not required. Participants need a computer with the current .NET SDK (.NET 10 or later), Visual Studio or VS Code with the C# Dev Kit, and SQL Server Express or LocalDB with the Northwind sample database (setup instructions provided).
How it works: Four days of instructor-led lectures, demonstrations, and hands-on labs built around an online product store. Contact us to discuss dates and virtual or onsite delivery.
Explore the course
Request a quote for the four-day C# and .NET Application Development course and discuss your team's training needs.