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
Possible locations:London, Manchester, Online
Next classroom course:No classroom dates
Time: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)
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?
- No more than 5 people per class
- Proper restaurant lunch included
- 536 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Rob Green (Ministry of Housing, Communities and Local Government (MHCLG))
Lianne Pierre John (Barbican Insurance / Arch Capital Gp Ltd)
Sarah Jowers (URIS Group/Towergate Insurance)
Antony Bateman (London Borough of Newham)
Jon Nagl (Government Internal Audit Agency (GIAA))
There are lots more where these came from (or just refresh this page to change the quotes shown).
Related Courses
Other Visual C# training resources
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
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
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