LINQ, LINQ to XML and LINQ to SQL

LINQ (32 Videos & Slides – 4 Hours 53 Minutes)
LINQ to XML (8 Videos & Slides – 1 Hour 5 Minutes)
LINQ to SQL (20 Videos & Slides – 2 Hours 25 Minutes)

What does the download contain

• • LINQ ( 32 Videos & Slides – 4 Hours 53 Minutes )
    1. What is LINQ | Text | Slides
    2. Writing LINQ Queries | Text | Slides
    3. Extension Methods | Text | Slides
    4. Aggregate Functions | Text | Slides
    5. Aggregate() Function | Text | Slides
    6. Restriction Operators | Text | Slides
    7. Projection Operators | Text | Slides
    8. SelectMany Operator | Text | Slides
    9. Select v/s SelectMany | Text | Slides
    10. Ordering Operators | Text | Slides
    11. Ordering Operators in LINQ II | Text | Slides
    12. Partitioning Operators | Text | Slides
    13. Implement paging using skip and take operators | Text | Slides
    14. LINQ query deferred execution | Text | Slides
    15. Conversion Operators in LINQ | Text | Slides
    16. Cast and OfType operators in LINQ | Text | Slides
    17. AsEnumerable and AsQueryable in LINQ | Text | Slides
    18. GroupBy in LINQ | Text | Slides
    19. Group by multiple keys in linq | Text | Slides
    20. Element Operators in LINQ | Text | Slides
    21. Group Join in LINQ | Text | Slides
    22. Inner Join in LINQ | Text | Slides
    23. Difference between group join and inner join in linq | Text | Slides
    24. Left Outer Join in LINQ | Text | Slides
    25. Cross Join in LINQ | Text | Slides
    26. Set operators in LINQ | Text | Slides
    27. Union, Intersect and Except operators in LINQ | Text | Slides
    28. Generation Operators in LINQ | Text | Slides
    29. Concat operator in LINQ | Text | Slides
    30. SequenceEqual Operator in LINQ | Text | Slides
    31. Quantifiers in LINQ | Text | Slides
    32. LinqPad | Text | Slides

• • LINQ to XML ( 8 Videos & Slides – 1 Hour 5 Minutes )
    1. LINQ to XML | Text | Slides
    2. Creating an XML document | Text | Slides
    3. Querying xml document | Text | Slides
    4. Modifying xml document | Text | Slides
    5. Transforming XML to CSV | Text | Slides
    6. Transforming XML to HTML table | Text | Slides
    7. Transform one XML format to another XML format | Text | Slides
    8. XML validation against XSD | Text | Slides

• LINQ to SQL ( 20 Videos & Slides – 2 Hours 25 Minutes )
  1. LINQ to SQL | Text | Slides
  2. Insert Update Delete using LINQ to SQ | Text | Slides
  3. How to view LINQ to SQL generated SQL queries | Text | Slides
  4. Using stored procedures with LINQ to SQL | Text | Slides
  5. Insert Update Delete using stored procedures | Text | Slides
  6. Stored procedures with output parameters | Text | Slides
  7. What is SqlMetal | Text | Slides
  8. Lazy loading | Text | Slides
  9. Eager loading | Text | Slides
  10. Difference between eager loading and lazy loading | Text | Slides
  11. Single table inheritance in linq to sql | Text | Slides
  12. Single table inheritance saving to database | Text | Slides
  13. Compiled queries in Linq to SQL | Text | Slides
  14. How to directly execute sql queries | Text | Slides
  15. Identity Cache in Linq to SQL | Text | Slides
  16. Difference between optimistic and pessimistic concurrency control | Text | Slides
  17. Concurrency in Linq to SQL | Text | Slides
  18. Handling ChangeConflictException | Text | Slides
  19. UpdateCheck property | Text | Slides
  20. Using ROWVERSION or TIMESTAMP to detect concurrency conflicts | Text | Slides