|
|
1-800-THE-TREE (1-800-843-8733)
|
|
|
 |
|
Programming LINQ and C# Extended Features: Hands-OnStreamlining Data-Centric Applications
Course: 973
Type: Hands-On Training
Duration: 4 Days
You Will Learn How To
- Streamline data-centric applications with C# extended features including LINQ
- Apply lambda expressions and extension methods for middle-tier data processing
- Exploit Language INtegrated Query (LINQ) keywords to filter and order data
- Access databases with DataContext objects via the Entity Framework (EF)
- 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 3.5 extended features enable programmers to streamline code, increase productivity and improve overall performance of applications. In this course, you apply C# 3.0 extended features, including LINQ, 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). 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 initializers
- Writing lambda expressions and extension methods
- Implementing the data tier with LINQ
- 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 973 Content
- Review of object-oriented programming
- Implementing to an interface
- Existing data-access technologies
- Generic and non-generic collections
- Applying auto-implemented properties
- Benefiting from implied-type declaration
- Instantiating entity objects
- Simplifying construction with object initializers
- Anonymous object construction
- Constructing lambda expressions
- Comparing delegates and lambda expressions
- Calling Where, OrderBy and other extension methods
- Passing types and functionality into methods
- Making code more flexible with delegates
- Parameterizing delegates and lambda expressions
- Streamlining code with anonymous types
- Coding LINQ queries
- Ordering data and objects
- Filtering using from, where, orderby and group
- Interfacing between C# and LINQ using IEnumerable<T>
- Converting from IEnumerable<T> to List<T>
- DataSet objects vs. generic lists
- SqlDataReader vs. IEnumerable<T>
- Processing data-tier information
- Establishing a DataContext
- Attaching to databases via the Entity Framework (EF)
- Correlating entity classes and data tables
- Preserving the object-oriented paradigm
- Mapping data tables to entity classes
- Establishing inheritance relationships
- Inserting, updating and deleting data
- Error handling and exceptions
- Committing and rolling back transactions
- Comparing IEnumerable<T> and IEnumerator<T>
- Generating dynamic enumeration
- The yield keyword
- Reducing duplicate classes
- Implementing a generic fast enumerator
- Combining and aggregating similar data with group
- Performing inner, outer and group joins
- Generating data subsets with the into clause
- Creating anonymous query results
- Retrieving composite views using nested from clauses
- Enhancing LINQ queries using delegates and lambda expressions
- Writing stored procedures in C#
- Calling stored procedures
- Retrieving the document, elements and attributes
- Parsing an XML document using LINQ
|
Related Courses
|
|
|
|
|
|
|
Print Friendly
E-mail a Colleague
Course FAQ
Course PDF
Home
