LINQ Quickly Table of Contents

Table of Contents

• 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