LINQ

LINQ – Table of Contents:

• Introduction to LINQ
• LINQ Architecture
  • Integration with SQL
  • Integration with XML
• Support for C# Language Support
  • Anonymous Types
  • Object Initializers
    • Collection Initializers
    • Partial Methods
  • Implicitly Typed Local Variables
  • Extensions
  • Expressions
    • Lambda Expressions
    • Query Expressions
    • Expression Trees
• LINQ to Objects
  • Array of Integers
  • Collection of Objects
  • Reading from Strings
  • Reading from Text Files
• LINQ to XML
  • Features
    • Classes and Hierarchy
      • XElement Class
      • XAttribute Class
      • XDocument Class
      • Other Classes
  • LINQ to XML with Other XML Technologies
    • LINQ with XmlReader
    • LINQ with XSLT
      • LINQ with MSXML
      • Functional Construction
  • XML Names
  • Loading and Traversing XML
    • Loading XML
    • Traversing XML
  • Data Manipulation
    • Inserting or Adding Elements to XML
    • Inserting or Adding XML Attributes
    • Deleting XML
    • Updating XML
    • Deleting XML Attributes
    • Updating XML Attributes
  • Outputting and Streaming XML
    • Streaming XML
  • Querying XML
    • Query Operators
    • Queries
    • Ancestors and Descendants
    • XML Transformation
    • Dictionaries
      • Convert Dictionary to XML
      • Create Dictionary from XML
  • Writing XML as Text Files and CSV Files
  • Reading from CSV Files
  • LINQ to XML Events
  • XML Literals and Embedded Expressions in Visual Basic
• LINQ to SQL
  • Working with Databases Using DataContext
  • Entity Classes
    • Attributes
    • Database Attribute
    • Table Attribute
    • Column Attribute
    • Association Attribute (Foreign Keys)
    • Relationships
    • Function Attribute
    • Parameter Attribute
    • Inheritance Mapping Attribute
  • Creating and Deleting Databases
  • DataContext Methods
  • Data Manipulation
  • LINQ to SQL Queries
    • Identifying Objects
    • Queries with Multiple Entities
      • Remote Queries and Local Queries
      • Deferred Loading
      • Immediate Loading
      • Projections
    • Constructing XML
    • Joins
    • Raw SQL Query
    • Query Result
    • Stored Procedures
      • User-Defined Functions
      • Class Generator Tool
    • Transactions
    • Handling Concurrency Conflicts
  • Object Relational Designer (O/R Designer)
• LINQ over DataSet
  • Loading Data into DataSets
  • Querying Datasets
  • Sequence Operator
  • Querying Typed DataSets
  • DataSet Query Operators
    • CopyToDataTable
    • LoadDataRow
    • Intersect
    • Union
    • Except
    • Field<T>
    • SetField<T>
  • Projection
  • Join
  • SequenceEqual
  • Skip
  • Distinct
• LINQ to XSD
  • Un-typed XML
  • Creating Typed XML using Visual Studio
    • Object Construction
    • Load Method
    • Parse Method
    • Save Method
    • Clone Method
    • Default Values
  • Customization of XML Objects
    • Mapping Time Customization
    • Compile Time Customization
    • Post Compile Customization
  • Using LINQ to XSD at Command Line
• Standard Query Operators
  • Restriction Operators
    • Where
    • OfType
  • Projection Operators
    • Select
    • SelectMany
  • Join Operators
    • Join
    • GroupJoin
  • Concatenation Operator
    • Concat
  • Ordering Operators
  • Set Operators
    • Distinct
    • Except
    • Intersect
    • Union
  • Grouping Operators
    • GroupBy
    • ToLookup
  • Conversion Operators
    • AsEnumerable
    • Cast
    • OfType
    • ToArray
    • ToDictionary
    • ToList
    • ToLookup
  • Equality Operators
    • SequenceEqual
  • Generation Operators
    • Empty
    • Range
    • Repeat
  • Quantifiers
    • All
    • Any
    • Contains
  • Aggregation Operators
    • Average
    • Count
    • LongCount
    • Min
    • Max
    • Sum
    • Aggregate
  • Partitioning Operators
    • Take
    • Skip
    • TakeWhile
    • SkipWhile
    • TakeWhile
  • Element Operators
    • DefaultIfEmpty
    • ElementAt
    • ElementAtOrDefault
    • First
    • FirstOrDefault
    • Last
    • LastOrDefault
    • Single
    • SingleOrDefault
  • List of Query Operators
    • Query Operator Equivalent Expressions
• Eliminate SQL Injection attacks with LINQ
  • Anatomy of SQL Injection
  • Typical SQL Safeguards
  • Securing Data Access with LINQ