Building Interactive Queries with LINQPad -- Table of Contents -- Building Interactive Queries with LINQPad -- Credits -- About the Author -- About the Reviewers -- www.PacktPub.com -- Support files, eBooks, discount offers and more -- Why Subscribe? -- Free Access for Packt account holders -- Instant Updates on New Packt Books -- Preface -- What this book covers -- What you need for this book -- Who this book is for -- Conventions -- Reader feedback -- Customer support -- Downloading the example code -- Errata -- Piracy -- Questions -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- 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 -- Index.