LINQ Quickly Table of Contents

Back to BOOK PAGE

Table of Contents

Preface
Chapter 1: Overview
Chapter 2: LINQ to Objects
Chapter 3: LINQ to XML
Chapter 4: LINQ to SQL
Chapter 5: LINQ over DataSet
Chapter 6: LINQ to XSD
Chapter 7: Standard Query Operators
Appendix A: Building an ASP.NET Application
Appendix B: LINQ with Outlook
Index

• Preface

• Chapter 1: Overview
  • LINQ Architecture
  • Integration with SQL
  • Integration with XML
  • Support for C# 3.0 Language Features
    • Anonymous Types
    • Object Initializers
      • Collection Initializers
      • Partial Methods
    • Implicitly Typed Local Variables
    • Extensions
    • Expressions
      • Lambda Expressions
      • Query Expressions
      • Expression Trees
  • Summary

• Chapter 2: LINQ to Objects
  • Array of Integers
  • Collection of Objects
  • Reading from Strings
  • Reading from Text Files
  • Summary

• Chapter 3: 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
• Summary

• Chapter 4: 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)
  • Summary

• Chapter 5: 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
  • Summary

• Chapter 6: 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
  • Summary

• Chapter 7: 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

• Summary

• Appendix A: Building an ASP.NET Application

• Appendix B: LINQ with Outlook

• Index

Back to BOOK PAGE