Building Interactive Queries with LINQPad

Chapter 1: Discovering LINQPad Chapter 2: Coding in LINQPad Chapter 3: Learning LINQ's Basics Chapter 4: Discovering LINQ Query Operators Chapter 5: Database and Relational Data Chapter 6: Using Other Data Sources Chapter 7: Getting More Out of LINQPad Index Preface Up Chapter 1: Discovering LINQPad Downloading and installing LINQPad Editions available Look and feel of LINQPad The File menu The Edit menu The Query menu The Help menu Configuring LINQPad The Editor tab The Query tab The Results tab The Folders tab The Web proxy tab The Advanced tab Summary Up Chapter 2: Coding in LINQPad Writing your first LINQPad query Query types The C#/F#/VB expression The C# and VB statement The C#, F#, and VB programs SQL/ESQL Referencing additional assemblies Adding it manually Adding it with NuGet Referencing additional namespaces LINQPad s Dump() method Summary Up Chapter 3: Learning LINQ's Basics The fundamentals of LINQ The purpose of LINQ A LINQ query The standard version The LINQ version Query operators Chaining calls One LINQ, two syntaxes Summary Up Chapter 4: Discovering LINQ Query Operators Defining LINQ to objects Query operators Quantifier operations The Any() query operator The All() query operator The Contains() query operator Filtering operations The Where() query operator The OfType() query operator Sorting operations The OrderBy() and OrderByDescending() query operators The ThenBy() and ThenByDescending() query operators The Reverse() query operator Partitioning operations The Take() and TakeWhile() query operators The Skip() and SkipWhile() query operators Summary Up Chapter 5: Database and Relational Data Introducing LINQ to SQL Setting up a database Adding a connection to LINQPad Interacting with the database Looking into the categories Filtering the categories Element operations The First() and FirstOrDefault() query operators The Single() and SingleOrDefault() query operators The Last() and LastOrDefault() query operators The ElementAt() and ElementAtOrDefault() query operators Conversion operations The ToArray() and ToList() query operators The ToDictionary() and ToLookup() query operators Deferred execution Grouping operations The GroupBy() query operator Working with relational data Interactive navigation with LINQPad Projection operations The Select() query operator The SelectMany() query operator Inserting, updating, and deleting data Adding a new entry to the database Updating entries from the database Deleting data from the database Views and Stored Procedures Acknowledging LINQ to SQL limits Summary Up Chapter 6: Using Other Data Sources Handling XML Creating and querying an XML fragment Aggregation operations The Average() and Sum() query operators The Max() and Min() query operators The Count() and LongCount() query operators Using XPath Other operations Discovering Entity Framework Setting up the context Running your first Entity Framework query Join operations The Join() query operator The GroupJoin() query operator Interacting with WCF Data Services Adding a connection to a service Making your first request to the service Summary Up Chapter 7: Getting More Out of LINQPad Customizing LINQPad Customizing the results pane Writing a custom visualizer SQL querying Exporting data Searching your queries Leveraging the Util class Summary