Building Interactive Queries with LINQPad. (2013)

• Record Type: Book
• Other Names: Finot, Sébastien
• Contents: Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Discovering LINQPad; Downloading and installing LINQPad; Editions available; Look and feel of LINQPad; File menu; Edit menu; Query menu; Help menu; Configuring LINQPad; Editor tab; Query tab; Results tab; Folders tab; Web proxy tab; Advanced tab; Summary; Chapter 2: Coding in LINQPad; Writing your first LINQPad query; Query types; C♯/F♯/VB expression; C♯ and VB statement; C♯, F♯, and VB program; SQL/ESQL; Referencing additional assemblies; Adding it manually. Adding it with NuGetReferencing additional namespaces; LINQPad's Dump() method; Summary; Chapter 3: Learning LINQ Basics; The fundamentals of LINQ; The purpose LINQ; A LINQ query; The standard version; The LINQ version; The query operators; Chaining calls; One LINQ, two syntaxes; Summary; Chapter 4: Discovering LINQ Query Operators; Defining LINQ to objects; Query operators; Quantifier operations; Any() query operator; All() query operator; Contains() query operator; Filtering operations; Where() query operator; OfType() query operator; Sorting operations. OrderBy() and OrderByDescending() query operatorsThenBy() and ThenByDescending() query operators; Reverse() query operator; Partitioning operations; Take() and TakeWhile() query operators; Skip() and SkipWhile() query operators; Summary; 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; First() and FirstOrDefault() query operators; Single() and SingleOrDefault() query operators. Last() and LastOrDefault() query operatorsElementAt() and ElementAtOrDefault() query operators; Conversion operations; ToArray() and ToList() query operators; ToDictionary() and ToLookup() query operators; Deferred execution; Grouping operations; GroupBy() query operator; Working with relational data; Interactive navigation with LINQPad; Projection operations; Select() query operator; 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 limitsSummary; Chapter 6: Using other Data Sources; Handling XML; Creating and querying an XML fragment; Aggregation operations; Average() and Sum() query operators; Max() and Min() query operators; Count() and LongCount() query operators; Using XPath; Other operations; Discovering Entity Framework; Setting up the context; Running your first Entity Framework query; Join operations; Join() query operator; GroupJoin() query operator; Interacting with WCF Data Services; Adding a connection to a service; Making your first request to the service; Summary.
• Publisher Details: Place of publication not identified : Packt Publishing
• Publication Date: 2013
• Extent: 1 online resource
• Subjects: 005.741; COMPUTERS -- Programming Languages -- C#; Query languages (Computer science); Query languages (Computer science); COMPUTERS -- Desktop Applications -- Databases; COMPUTERS -- Database Management -- General; COMPUTERS -- System Administration -- Storage & Retrieval; Query languages (Computer science); Query languages (Computer science); COMPUTERS -- Databases -- General; Electronic books
• Languages: English
• ISBNs: 9781782178231; 1782178236; 1299783759; 9781299783751; 1782178228; 9781782178224
• Related ISBNs: 9781782178224
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.