LINQ

What is LINQ? Why do we need LINQ? Discuss Advantages and disadvantages of LINQ?
Compare ADO.Net vs LINQ to SQL
Compare LINQ to SQL vs LINQ to Entities
Compare XML API to LINQ to XML
Compare LINQ to Xml characteristics vs XML DOM Characteristics
Compare Differed loading (executing) vs immediate loading?
How to read from .mdf file?
What are lamba expressions?
Compare lambda expressions with anonymous methods?
How to write a lambda expression which takes two parameters? Where is the return type specified?
SelectMany  vs Select
Selecting Authors when querying books?
Design Patterns in LINQ?
Discuss few query operators like Where, Select, Join, OrderBy, GroupBy, Skip, Take, Except, Distinct, All, Any,OfType,
Interset, Union,DefaultIfEmpty, Empty, Range, Repeat, First, Last,Single, SingleOrDefault
How to write left outer join? Expalin DefaultIfEmpty
What are ExpressionTrees?
Discuss IQueryable  .. Compare it with IEnumerable
Discuss accessing Array and ArrayList using LINQ
How to write Nested Queries in LINQ?
Explicit and implicit casting when using ArrayList in LINQ
Explain Grouping by multiple criteria
How to parameterize a LINQ query?
How to call custom methods in LINQ expression?
Explain creating a query at runtime using ExpressionTree
Discuss LINQ to TextFiles
Design Patterns: The Functional Construction pattern, The ForEach pattern
What operators execute immediately?
Answer  -- Aggregate, Average, Count, LongCount, Max, Min, and Sum    OrderBy, OrderByDescending, and Reverse
How to write a join query with out using 'join' keyword?
How to map a Table to a class ?
How to represent primary, foreign key and constraints?
How to load details when loading a (master)table?  DataLoadOptions?
DataLoadOptions.LoadWith<Subject>
Discuss ObjectTrackingEnabled  of DataContext?
ChangeConflictException
How to handle transactions?
use of TransactionScope object
How to execute sql queries from Datacontext?
CompiledQuery.Compile
ADO.Net Entity Framework , Entity Data Model
XElement Vs XDocument
How to Create an XElement from an existing XmlReader? from a fragment of XML contained within an XmlReader?
Descendants vs DescendantsAndSelf
ancestors, ElementsAfterSelf, NodesAfterSelf, ElementsBeforeSelf, and NodesBeforeSelf