|
|
|
You Will Learn How To
- Streamline data-centric applications with C# extended features and the Entity Framework (EF)
- Apply lambda expressions and extension methods for middle-tier data processing
- Exploit Language INtegrated Query (LINQ) keywords to filter and order data
- Simplify complex logic with generic Func<T,R> delegates
- Generate dynamic enumerations using IEnumerable<T> within developer-written generic classes
- Leverage LINQ to write stored procedures in C# and simplify XML processing
Course Benefits C# has evolved since its introduction into a full data-manipulation language. .NET extended features enable programmers to streamline code, increase productivity and improve overall performance of applications. In this course, you apply C# extended features, including LINQ and EF, to effectively integrate the object-oriented and data-manipulation capabilities.
Who Should Attend Experienced C# programmers who want to improve their software development capabilities by using extended language features, and in particular Language Integrated Query (LINQ), in conjunction with the Entity Framework. C# programming experience at the level of Course 419, " C# Programming", is assumed.
Hands-On Training Exercises using a progressive case study provide experience applying C# extended features and include:
- Applying auto-properties and object initialisers
- Writing lambda expressions and extension methods
- Implementing the data tier with LINQ and EF
- Employing DataContext objects and LINQ query keywords to access and update a database
- Mapping entity classes using the O/R Designer
- Achieving dynamic enumerations with yield
- Parsing XML documents using LINQ
- Installing C#/LINQ stored procedures
Course Content Introduction
- Review of object-oriented programming
- Implementing to an interface
- Existing data-access technologies
- Generic and nongeneric collections
Harnessing C# Language Features
Language shortcuts
- Applying auto-implemented properties
- Benefiting from implied-type declaration
Streamlining program logic
- Instantiating entity objects
- Simplifying construction with object initialisers
- Anonymous object construction
Employing Extension Methods for Middle-Tier Data Manipulation
Filtering and ordering data with lambda expressions
- Constructing lambda expressions
- Comparing delegates and lambda expressions
- Calling Where, OrderBy and other extension methods
- Passing types and functionality into methods
Applying extended features
- Making code more flexible with delegates
- Parameterising delegates and lambda expressions
- Streamlining code with Func<T,R> generic delegates
Leveraging LINQ Query Keywords
Syntax and semantics
- Coding LINQ queries
- Ordering data and objects
- Filtering using from, where, orderby and group
Iterating collections
- Interfacing between C# and LINQ using IEnumerable<T>
- Converting from IEnumerable<T> to List<T>
Adapting LINQ and EF
Comparing ADO.NET with LINQ
- DataSet objects vs. generic lists
- SqlDataReader vs. IEnumerable<T>
- Processing data-tier information
Connecting to and reading from a database
- Establishing an ObjectContext
- Attaching to databases via the Entity Framework (EF)
- Correlating entity classes and data tables
- Preserving the object-oriented paradigm
The Object Relational Designer tool
- Mapping data tables to entity classes
- Establishing inheritance relationships
Updating a database
- Inserting, updating and deleting data
- Error handling and exceptions
- Committing and rolling back transactions
Enumerations and Generic Classes
Examining enum
- Comparing IEnumerable<T> and IEnumerator<T>
- Generating dynamic enumeration
- The yield keyword
Writing generic classes
- Reducing duplicate classes
- Implementing a generic fast enumerator
Processing Data with LINQ Queries
Manipulating data
- Combining and aggregating similar data with group
- Performing inner, outer and group joins
- Generating data subsets with the into clause
Advanced LINQ techniques
- Creating anonymous query results
- Retrieving composite views using nested from clauses
- Enhancing LINQ queries using delegates and lambda expressions
Applying LINQ to Stored Procedures and XML
Exploiting stored procedures
- Writing stored procedures in C#
- Calling stored procedures
Processing XML
- Retrieving the document, elements and attributes
- Parsing an XML document using LINQ
|
<< Back to Visual Studio and .NET Course List
Related Courses
|
|
Course Dates
Attend highlighted events
in person or online with Learning Tree AnyWareTM.
More Dates and locations.
On-Site &
Custom Training
Bring this or any Learning Tree course to your location or have it customised for your organisation.
|
|
|
Participants integrating the object-oriented and relational models in C#.
|
"I recommend Learning Tree because everything is concise. You learn a lot and get a wealth of experience—more than if you were just reading from a book. It's a concentrated period of time that gives you exactly what you need and more". M. Young
Security Officer
ES (Air) DBI |
|
|
E-mail a Colleague
Print Friendly
FAQ
Course Details PDF