Browse 556 attributed reviews, viewable separately for our classroom and online training
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 11 November 2021
  • 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).

"The trainer was very knowledgeable and approachable."

Ian Reacord (RAC)

"Top Trainer who kept the course and info interesting and fun to learn. Very friendly and polite."

Chris Clarey (Liquid Logic (System C))

"Really enjoyed the SQL course and it worked well online."

Sarah Penn (Sellafield Ltd)

"Really enjoyed the course. Great pace. Learnt loads of useful tips. Looking forward to advanced course. Great website."

Nicola Leah (Shell International Trading and Shipping Company Ltd.)

"Really enjoyable course with the trainer's good humour; made an intense couple of days very accessible. Content was well structured & was at a good pace to not feel bored or too fast!"

Harry Matthews (PricewaterhouseCoopers)

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 11-12 November 2021 2 £795 Book places
Date(s) Venue
11/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