Topics

• LINQ Queries
• Getting started with linq
• LINQ
• Scripting.Dictionary object
• Method execution modes - immediate, deferred streaming, deferred non-streaming

Examples

• Setup
• Incrementally building a query
• Deferred execution vs immediate execution
• Streaming mode (lazy evaluation) vs non-streaming mode (eager evaluation)
• Benefits of deferred execution - building queries
• Benefits of deferred execution - querying current data
• Aggregating data with Scripting.Dictionary (Maximum, Count)
• LINQ methods, and IEnumerable<T> vs IQueryable<T>
• Getting unique values with Scripting.Dictionary
• Getting distinct values (using the Distinct method)