Advanced C# Programming Training: Programming Extended Features

In this course, you will apply C# extended features, including definitive coverage Language Integrated Query (LINQ), to streamline the use of C# as both an object-oriented and a first-class data-manipulation language. C# is layered on top of Microsoft’s highly successful .NET Framework. With the advent of Core, the extra dimensions of portability and openness have been added. As a result, different language features are required to effectively leverage the integration of programs with both .NET Framework and Core, including specialized C# keywords, advanced lambda expressions, extension methods, generic classes and delegates, universal functions, and anonymous types. In particular, to optimize data access, productivity, and overall application performance. Advanced C# Programming Training: Programming Extended Features Benefits Streamline data-centric applications with C# extended features and the Entity Framework (EF) Integrate Microsoft Core with .NET Framework applications for high-performance data access Exploit LINQ keywords and full-stack capabilities including queries, grouping and joins Generate dynamic enumerations in developer-written generic classes Leverage continued support with after-course one-on-one instructor coaching and computing sandbox Advanced C# Programming Course Outline Important Course Information Prerequisites You should know how to: Construct, compile, and execute C# Windows Forms and/or Web applications using the Visual Studio integrated environment Design and implement a modestly complex (1000+ lines) program in the C# language Apply solid object-oriented development techniques, including encapsulation, inheritance, interfaces, and polymorphism Produce applications that employ key parts of the .NET framework library Module 1: Harnessing C# Language Features Language shortcuts Applying auto-implemented and lambda generated properties Benefiting from dynamic and implied-type declaration Streamlining program logic Instantiating entity objects Simplifying construction with object initializers Module 2: Employing Extension Methods for Middle-Tier Data Manipulation Filtering and ordering data with lambda expressions Passing lambda expressions to methods (behavior vs. data) Calling Count, Reverse, Union, Except and other extension methods Applying extended features Making code more flexible with delegates Parameterizing delegates and lambda expressions Streamlining code with Func<T,R> generic delegates Module 3: Leveraging LINQ Query Keywords Syntax and semantics Coding LINQ queries Filtering with from, where, orderby and group Performing inner and outer joins Iterating collections Interfacing between C# and LINQ using IEnumerable<T> and IQueryable<T> Issuing queries on entity and spatial types Module 4: Attaching to Databases via the Entity Framework Connecting to and reading from a database Inheriting Core DbContext objects Correlating entity classes and data tables Executing stored procedures and table-valued functions Object Relational Mapping Employing code-first and database first mapping to generate entity classes Optimizing complex mapping including many to many and database inheritance Updating a database Inserting, updating and deleting data when Core is integrated with .NET Framework Error handling and exceptions Committing and rolling back transactions Module 5: Enumerations and Generic Classes Dynamic Enumeration Comparing IEnumerable<T> and IEnumerator<T> The yield keyword Module 6: Processing Data with LINQ Queries Advanced LINQ techniques Creating anonymous query results Retrieving composite views using nested from clauses