COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Intermediate C#

Classroom Training

Intermediate C# training course - Classes, LINQ and Entity Frameworks

Classroom training course - online version also available

£795 + VAT for most venues (£895 + VAT for London)

2 days

This intermediate-level C# course assumes that you're already familiar with the basics of C# programming (so you know how to use variables, write conditions and create loops).  You suspect (correctly) that the key to understanding C# is knowing how to create and use classes, and you'd also like to learn a quick and easy way to access data so that you can use it in your application.

Course details

  • Locations for Intermediate C# coursesPossible locations:London, Manchester, Online
  • Next Intermediate C# course locationNext classroom course:Thu 19 November 2020
  • Intermediate C# course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Designing classes

  • The domestic cat object
  • Properties and methods
  • Encapsulation and exposure

Creating classes

  • Using namespaces
  • Creating constructors
  • Fields, properties and methods
  • Static members

The form as a class

  • Partial classes
  • InitalizeComponent method
  • Instantiating forms

Data structures

  • Generics
  • Arrays
  • Lists, stacks and queues
  • Dictionaries

Overloading

  • Overloaded methods
  • Overloading constructors

LINQ theory

  • Extension methods
  • Ienumerability
  • Query vs. method syntax

Writing LINQ

  • Arrays, lists and data tables
  • Criteria and ordering
  • Using LET expressions

Advanced LINQ

  • Projecting data
  • Anonymous types
  • Forcing query execution
  • Taking and skipping

Types of model

  • Code first
  • Model first
  • Database first

Entity Frameworks

  • Creating entity data models
  • Data contexts
  • Updating models

LINQ with Entity Frameworks

  • Creating a data context
  • Selecting data using LINQ
  • Using relationships (associations)
  • Adding, editing and deleting

Advanced LINQ with EF

  • Returning anonymous types
  • Using stored procedures
  • Extending (partial classes)

Covered if time allows If time

Grouping using LINQ

  • IGrouping and IEnumerable
  • Grouping keys
  • Group into and ordering
  • Using multiple keys

You should not attend this course if you are a beginner at C programming (in which case choose our two-day introduction to C# course instead).

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Great trainer & course. Would highly recommend."

David Kirby (Waltham Forest Council)

"Trainer and course are engaging. Comprehensive and informative."

Andrew King (NHS Digital)

"Really useful course and very well presented."

Mike Hardiman (Aster Group Ltd)

"The trainer was brilliant. Examples with comments, manual and exercise book also super helpful for future reference."

George Kelly (CFC Underwriting)

"The whole course has been really useful, friendly and just a great course. Given me lots of ideas to take away. Trainer is supportive and helpful. Great 2 days! Highly recommended by a number of colleagues."

Becky Leason (Department of Health)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Intermediate C# training dates

Here are the classroom Intermediate C# courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Thu/Fri 19-20 November 2020 2 £795 Book places
Date(s) Venue
19/11

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite C# training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to Visual C#

Introduction

2 day course

Other Visual C# training resources

C# exercises

C# exercises

We publish all of our exercises online, so have a look at our C# exercises (particularly the advanced ones) to see if you like our approach before booking any training.

View C Sharp exercises

C# videos

C# videos

There are a range of video tutorials to help you learn C# (although there's no substitute for learning from a human being - or Wise Owl, at any rate).

View C# Programming videos

C# blogs

C# blogs

As well as other C# training resources, you may find some of our blogs on the language useful - or at least interesting!

View Visual C# blogs

This page has 0 threads Add post