Microsoft.NET

……………………………………………….Expertise in .NET Technologies

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

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: