| Description |
1 online resource |
| Physical Medium |
polychrome |
| Description |
text file |
| Summary |
A step-by-step practical guide that will introduce you to LINQPad's key features, thereby helping you to query databases interactively. This book is aimed at C♯/.Net developers who wish to learn LINQ programming and leverage the easy way of using LINQPad. No prior knowledge of LINQ or LINQPad is expected. A basic knowledge of SQL and XML is required for some chapters. |
| 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. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Microsoft LINQ.
|
|
Microsoft LINQ. |
|
Microsoft LINQ. |
|
Microsoft LINQ. |
|
Microsoft LINQ. |
|
Query languages (Computer science)
|
|
Query languages (Computer science) |
| Genre/Form |
Electronic books.
|
| ISBN |
9781782178231 (electronic book) |
|
1782178236 (electronic book) |
|
1299783759 (electronic book) |
|
9781299783751 (electronic book) |
|
1782178228 |
|
9781782178224 |
|
9781782178224 |
|
