Index
A
- Add() method / Other operations
- advanced tab, LINQPad configuration
- about / The Advanced tab
- aggregation operations
- Sum() / The Average() and Sum() query operators
- Average() / The Average() and Sum() query operators
- Max() / The Max() and Min() query operators
- Min() / The Max() and Min() query operators
- Count() / The Count() and LongCount() query operators
- LongCount() / The Count() and LongCount() query operators
- All() query operator
- about / The All() query operator
- Any() query operator
- about / The Any() query operator
- assembly
- adding, manually / Adding it manually
- adding, NuGet used / Adding it with NuGet
- Average() query operator
C
- C#/F#/VB expression
- about / The C#/F#/VB expression
- C#/F#/VB program
- about / The C#, F#, and VB programs
- C#/VB statement
- about / The C# and VB statement
- conversion query operators
- ToArray() / The ToArray() and ToList() query operators
- ToList() / The ToArray() and ToList() query operators
- ToDictionary() / The ToDictionary() and ToLookup() query operators
- ToLookup() / The ToDictionary() and ToLookup() query operators
- Count() query operator
- custom visualizer
- about / Writing a custom visualizer
- writing / Writing a custom visualizer
D
- data
- exporting / Exporting data
- deferred execution / Deferred execution
- Dump() method
- about / LINQPad's Dump() method
E
- edit menu, LINQPad
- about / The Edit menu
- menu items / The Edit menu
- editor tab, LINQPad configuration
- about / The Editor tab
- ElementAt() query operator
- ElementAtOrDefault() query operator
- Entity Framework
- about / Discovering Entity Framework
- context, setting up / Setting up the context
- join operations / Join operations
- Entity Framework query
F
- file menu, LINQPad
- about / The File menu
- menu items / The File menu
- filtering operations
- about / Filtering operations
- Where() query operator / The Where() query operator
- OfType() query operator / The OfType() query operator
- First() query operator / The First() and FirstOrDefault() query operators
- FirstOrDefault() query operator
- folders tab, LINQPad configuration
- about / The Folders tab
G
- GroupBy() query operator
- about / The GroupBy() query operator
- grouping query operators
- GroupBy() / The GroupBy() query operator
- GroupJoin() query operator
- about / The GroupJoin() query operator
H
- help menu, LINQPad
- about / The Help menu
- menu items / The Help menu
I
- interactive navigation
J
- Join() query operator
- about / The Join() query operator
- join operations
- about / Join operations
- Join() query operator / The Join() query operator
- GroupJoin() query operator / The GroupJoin() query operator
L
- lambda expression / The LINQ version
- Last() query operator
- LastOrDefault() query operator
- LINQ
- about / The fundamentals of LINQ
- libraries / The fundamentals of LINQ
- framework / The fundamentals of LINQ
- purpose / The purpose of LINQ
- XML handling / Handling XML
- Entity Framework / Discovering Entity Framework
- WCF Data Services, interacting with / Interacting with WCF Data Services
- LINQ element query operators
- First() / The First() and FirstOrDefault() query operators
- FirstOrDefault() / The First() and FirstOrDefault() query operators
- Single() / The Single() and SingleOrDefault() query operators
- SingleOrDefault() / The Single() and SingleOrDefault() query operators
- Last() / The Last() and LastOrDefault() query operators
- LastOrDefault() / The Last() and LastOrDefault() query operators
- ElementAt() / The ElementAt() and ElementAtOrDefault() query operators
- ElementAtOrDefault() / The ElementAt() and ElementAtOrDefault() query operators
- LINQPad
- downloading / Downloading and installing LINQPad
- URL / Downloading and installing LINQPad
- pro version / Editions available
- premium version / Editions available
- startup screen / Look and feel of LINQPad
- upper left window / Look and feel of LINQPad
- lower right window / Look and feel of LINQPad
- file menu / The File menu
- edit menu / The Edit menu
- query menu / The Query menu
- help menu / The Help menu
- configuring / Configuring LINQPad
- query types / Query types
- assemblies / Referencing additional assemblies
- assemblies, adding manually / Adding it manually
- assemblies, adding with NuGet / Adding it with NuGet
- namespaces / Referencing additional namespaces
- Dump() method / LINQPad's Dump() method
- interactive navigation / Interactive navigation with LINQPad
- customizing / Customizing LINQPad
- result pane, customizing / Customizing the results pane
- custom visualizer, writing / Writing a custom visualizer
- SQL querying / SQL querying
- data, exporting / Exporting data
- Util class, leveraging / Leveraging the Util class
- LINQPad configuration
- about / Configuring LINQPad
- editor tab / The Editor tab
- query tab / The Query tab
- results tab / The Results tab
- folders tab / The Folders tab
- web proxy tab / The Web proxy tab
- advanced tab / The Advanced tab
- LINQPad query
- creating / Writing your first LINQPad query
- searching / Searching your queries
- LINQ query
- about / A LINQ query
- standard version / The standard version
- LINQ version / The LINQ version
- query operators / Query operators
- calls, chaining / Chaining calls
- query syntax / One LINQ, two syntaxes
- LINQ to entity
- LINQ to objects
- about / The fundamentals of LINQ
- defining / Defining LINQ to objects
- query operators / Query operators
- LINQ to SQL
- about / The fundamentals of LINQ, Introducing LINQ to SQL
- database, setting up / Setting up a database
- connection, adding to LINQPad / Adding a connection to LINQPad
- database, interacting with / Interacting with the database
- categories, viewing / Looking into the categories
- categories, filtering / Filtering the categories
- element operations / Element operations
- conversion operations / Conversion operations
- deferred execution / Deferred execution
- grouping operations / Grouping operations
- relational data, working with / Working with relational data
- projection operations / Projection operations
- data, inserting / Adding a new entry to the database
- entries, updating from database / Updating entries from the database
- data, deleting from database / Deleting data from the database
- SQL Views and Stored Procedures / Views and Stored Procedures
- limits, acknowledging / Acknowledging LINQ to SQL limits
- LINQ to XML
- about / The fundamentals of LINQ, Handling XML
- LongCount() query operator
M
- Max() query operator
- Min() query operator
N
- namespaces
- NextNode() method / Other operations
- NTEXT / Acknowledging LINQ to SQL limits
- NuGet
- about / Adding it with NuGet
- URL / Adding it with NuGet
O
- OData
- OfType() query operator
- about / The OfType() query operator
- OrderBy() query operator / The OrderBy() and OrderByDescending() query operators
- OrderByDescending() query operator / The OrderBy() and OrderByDescending() query operators
- ORM (Object-Relational Mapper) / Discovering Entity Framework
P
- Parent() method / Other operations
- partitioning operations
- about / Partitioning operations
- Take() query operator / The Take() and TakeWhile() query operators
- TakeWhile() query operator / The Take() and TakeWhile() query operators
- Skip() query operator / The Skip() and SkipWhile() query operators
- SkipWhile() query operator / The Skip() and SkipWhile() query operators
- premium edition, LINQPad
- about / Editions available
- PreviousNode() method / Other operations
- pro edition, LINQPad
- about / Editions available
- projection query operators
- Select() / The Select() query operator
- SelectMany() / The SelectMany() query operator
Q
- quantifier operations
- about / Quantifier operations
- Any() query operator / The Any() query operator
- All() query operator / The All() query operator
- query menu, LINQPad
- about / The Query menu
- menu items / The Query menu
- query operators
- about / Query operators
- query operators, LINQ to objects
- quantifier operations / Quantifier operations
- filtering operations / Filtering operations
- sorting operations / Sorting operations
- partitioning operations / Partitioning operations
- query tab, LINQPad configuration
- about / The Query tab
- query types, LINQPad
- about / Query types
- C#/F#/VB expression / The C#/F#/VB expression
- C#/VB statement / The C# and VB statement
- C#/F#/VB program / The C#, F#, and VB programs
- SQL/ESQL / SQL/ESQL
R
- relational data, LINQ to SQL
- working with / Working with relational data
- RemoveNodes() method / Other operations
- result pane
- customizing / Customizing the results pane
- results tab, LINQPad configuration
- about / The Results tab
- reverse() query operator / The Reverse() query operator
S
- Select() query operator
- about / The Select() query operator
- SelectMany() query operator
- about / The SelectMany() query operator
- Single() query operator
- SingleOrDefault() query operator
- Skip() query operator / The Skip() and SkipWhile() query operators
- SkipWhile() query operator / The Skip() and SkipWhile() query operators
- sorting operations
- about / Sorting operations
- OrderBy() query operator / The OrderBy() and OrderByDescending() query operators
- OrderByDescending() query operator / The OrderBy() and OrderByDescending() query operators
- ThenBy() query operator / The ThenBy() and ThenByDescending() query operators
- ThenByDescending() query operator / The ThenBy() and ThenByDescending() query operators
- reverse() query operator / The Reverse() query operator
- SQL-CLR type mapping / Acknowledging LINQ to SQL limits
- SQL/ESQL
- about / SQL/ESQL
- SQL querying
- about / SQL querying
- SQL Views and Stored Procedures
- about / Views and Stored Procedures
- Sum() query operator
T
- Take() query operator / The Take() and TakeWhile() query operators
- TakeWhile() query operator / The Take() and TakeWhile() query operators
- ThenBy() query operator / The ThenBy() and ThenByDescending() query operators
- ThenByDescending() query operator / The ThenBy() and ThenByDescending() query operators
- Tuple / Interactive navigation with LINQPad
U
- Util class
- leveraging / Leveraging the Util class
- AutoScrollResults property / Leveraging the Util class
- Cache() / Leveraging the Util class
- ClearResults() / Leveraging the Util class
- Cmd() / Leveraging the Util class
- CurrentQueryPath / Leveraging the Util class
- DisplayWebPage() / Leveraging the Util class
- GetMyQueries() / Leveraging the Util class
- GetPassword() / Leveraging the Util class
- Highlight() / Leveraging the Util class
- HighlightIf() / Leveraging the Util class
- HorizonalRun() / Leveraging the Util class
- Image() / Leveraging the Util class
- Metatext() / Leveraging the Util class
- RawHtml() / Leveraging the Util class
- ReadLine() / Leveraging the Util class
- SetPassword() / Leveraging the Util class
- VerticalRun() / Leveraging the Util class
- WordRun() / Leveraging the Util class
- WriteCsv() / Leveraging the Util class
W
- WCF Data Services
- interacting with / Interacting with WCF Data Services
- connection, adding / Adding a connection to a service
- request, creating / Making your first request to the service
- web proxy tab, LINQPad configuration
- about / The Web proxy tab
- Where() query operator
- about / The Where() query operator
X
- XML handling
- about / Handling XML
- XML fragment, creating / Creating and querying an XML fragment
- XML fragment, querying / Creating and querying an XML fragment
- aggregation operations / Aggregation operations
- XPath, using / Using XPath
- XPath
- about / Using XPath
- using / Using XPath
- URL / Using XPath