Home > Training courses > Adv C# | Classes & LINQ

Adv C# | Classes & LINQ training course (3 days)

This course assumes that you're already familiar with the basics of C# programming (using variables, writing conditions and the like). The course starts with an overview of C# as an OOP (object-orientated programming) language, before looking at more advanced subjects, such as polymorphism and interfaces. Finally, the course shows how to use LINQ to get at data in SQL Server tables and stored procedures. The course is aimed either at those who know C++, or those who have attended one of our WPF, ASP.NET or WinForms courses and want to learn more about how to program in C#. At the time of writing, this course is taught using Visual Studio 2010, Visual C# 2010 and SQL Server 2008 R2.

Click here to show prices, dates and venues for this course

Adv C# | Classes & LINQ training - Course Contents

The contents of our Adv C# | Classes & LINQ course are as follows (any items marked with a * will be covered if time allows):

Object-oriented programming

Designing classes
Designing properties and methods
The concept of inheritance

Creating basic classes

Creating a new class
The types of property
Writing methods
Overloading methods

Inheritance

Design considerations
Inheriting classes
Overriding and Overrideable

Interfaces (*)

Single and multiple interfaces
Creating an interface
Interfaces versus inheritance

Creating generics

Concepts behind generics
Creating lists
Using lambda expressions

FileDialogs and StreamReaders

The standard file dialog boxes
StreamReaders and StreamWriters

Introduction to LINQ

Valid data sources
Creating queries
When queries execute

Selecting using LINQ

Setting WHERE criteria
Using the SELECT statement
Sorting
Calculations using LET

More complex LINQ statements

Using GROUP to group data
Using GROUP JOIN to combine
Returning one value using AGGREGATE
Skipping and taking rows

LINQ to SQL Designer

The graphical designer
Adding methods
The DataContext class
Lazy loading

Querying SQL using LINQ

Using Table Of
Amending records
Deleting records

Advanced SQL LINQ (*)

Using SKIP to page data
Calling stored procedures

Click on any link above to show free exercises for the topic in question. You should not attend this course if you are a beginner at C programming. If you already know how to create classes and implement inheritance this is not the course for you either. There will be a maximum of 6 people on each course, and each person will have their own computer.

Adv C# | Classes & LINQ training course (3 days)

Adv C# | Classes & LINQ training - Course Contents

RELATED TRAINING

MAIN LINKS

TYPES OF TRAINING

NEW COURSES