C# Training

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

£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:Manchester
Next course:Thu 31 January 2019
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

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

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
485 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"Great course with an enthusiastic tutor. Enjoyable two days."

Daniel Brooke (Investec Wealth Investment Limited)

"I was very impressed with the course training, the small group size and the material that we covered. I benefitted from the trainer spending extra time going through the report grouping sessions and I will be using these and extra skills in my work. In future I may consider Integration Services and Advanced SQL."

Simon Young (Derbyshire County Council)

"Very well explained and at a good pace that gave opportunities to ask questions, very good course. Material covered will be very useful going forward."

Andrew Appleton (Home Retail Group PLC)

"Very good content & a great tutor. In depth course but explained in a very user friendly way."

Ben Thrower (Frontline Ltd)

"Easy to use website, good location, good material."

Yiannis Theologos Michelus (Adsensa)

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

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).

Scheduled Intermediate C# training dates

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

Dates	Days	Venue	Price	Booking
Thu/Fri 31st Jan/1st February 2019	2	Manchester	£795	Book places
Tue/Wed 02-03 April 2019	2	Manchester	£795	Book places
Thu/Fri 06-07 June 2019	2	Manchester	£795	Book places
Tue/Wed 13-14 August 2019	2	Manchester	£795	Book places
Tue/Wed 24-25 September 2019	2	Manchester	£795	Book places
Thu/Fri 21-22 November 2019	2	Manchester	£795	Book places

Date(s)	Venue
31/01	Manchester
02/04	Manchester
06/06	Manchester
13/08	Manchester
24/09	Manchester
21/11	Manchester

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).