Building Interactive Queries with LINQPad

Learn how to query databases interactively using LINQ and LINQPad

Building Interactive Queries with LINQPad

Sébastien Finot

Learn how to query databases interactively using LINQ and LINQPad
Mapt Subscription
FREE
$29.99/m after trial
eBook
$16.80
RRP $23.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$16.80
$39.99
$29.99p/m after trial
RRP $23.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781782178224
Paperback126 pages

Book Description

If you need to interact with databases, XML, in-memory collections, or remote services, LINQ can make your life simpler. The best way to discover LINQ is with the help of LINQPad, a free IDE whose first goal is to make sure that writing and interacting with your LINQ query is fun and easy. More generally, LINQPad is a C#/VB/F# scratchpad that instantly executes any expression, statement block, or program with rich output formatting and a wealth of features.

With Building Interactive Queries with LINQPad, you will quickly learn everything you need to know to start using LINQ. To accelerate your learning curve, you will discover how to use LINQPad and its features to test your queries interactively and experiment with all the options offered by LINQ.

In all probability, you already know C#, but have you had a chance to try out LINQ? Building Interactive Queries with LINQPad will introduce you to everything LINQ can offer and will let you interact with every example in LINQPad, LINQ’s best companion.

You will learn how to build and experiment with interactive queries with this practical guide illustrated with short and detailed code samples. You will also get acquainted with other cool applications of LINQpad such as testing, code snippet generation, and so on, along with a broad approach to LINQ (to object, to SQL, to XML, and so on).

Table of Contents

Chapter 1: Discovering LINQPad
Downloading and installing LINQPad
Look and feel of LINQPad
Configuring LINQPad
Summary
Chapter 2: Coding in LINQPad
Writing your first LINQPad query
Query types
Referencing additional assemblies
Referencing additional namespaces
LINQPad's Dump() method
Summary
Chapter 3: Learning LINQ's Basics
The fundamentals of LINQ
The purpose of LINQ
A LINQ query
One LINQ, two syntaxes
Summary
Chapter 4: Discovering LINQ Query Operators
Defining LINQ to objects
Query operators
Summary
Chapter 5: Database and Relational Data
Introducing LINQ to SQL
Interacting with the database
Element operations
Conversion operations
Deferred execution
Grouping operations
Working with relational data
Projection operations
Inserting, updating, and deleting data
Views and Stored Procedures
Acknowledging LINQ to SQL limits
Summary
Chapter 6: Using Other Data Sources
Handling XML
Discovering Entity Framework
Interacting with WCF Data Services
Summary
Chapter 7: Getting More Out of LINQPad
Customizing LINQPad
SQL querying
Exporting data
Searching your queries
Leveraging the Util class
Summary

What You Will Learn

  • Discover what LINQ can do and how it will help you
  • Learn all about LINQ query operators to join, aggregate, select, and filter data
  • Write LINQ queries with both method and query syntaxes
  • Query databases and remote services using LINQ
  • Create and manipulate XML and in-memory collections
  • Differentiate LINQPad’s query types
  • Handle user input with LINQPad
  • Customize LINQPad to fit your taste or workflow

Authors

Table of Contents

Chapter 1: Discovering LINQPad
Downloading and installing LINQPad
Look and feel of LINQPad
Configuring LINQPad
Summary
Chapter 2: Coding in LINQPad
Writing your first LINQPad query
Query types
Referencing additional assemblies
Referencing additional namespaces
LINQPad's Dump() method
Summary
Chapter 3: Learning LINQ's Basics
The fundamentals of LINQ
The purpose of LINQ
A LINQ query
One LINQ, two syntaxes
Summary
Chapter 4: Discovering LINQ Query Operators
Defining LINQ to objects
Query operators
Summary
Chapter 5: Database and Relational Data
Introducing LINQ to SQL
Interacting with the database
Element operations
Conversion operations
Deferred execution
Grouping operations
Working with relational data
Projection operations
Inserting, updating, and deleting data
Views and Stored Procedures
Acknowledging LINQ to SQL limits
Summary
Chapter 6: Using Other Data Sources
Handling XML
Discovering Entity Framework
Interacting with WCF Data Services
Summary
Chapter 7: Getting More Out of LINQPad
Customizing LINQPad
SQL querying
Exporting data
Searching your queries
Leveraging the Util class
Summary

Book Details

ISBN 139781782178224
Paperback126 pages
Read More

Read More Reviews

Recommended for You

Responsive Web Design with HTML5 and CSS3 Book Cover
Responsive Web Design with HTML5 and CSS3
$ 23.99
$ 4.80
Mastering Web Application Development with AngularJS Book Cover
Mastering Web Application Development with AngularJS
$ 26.99
$ 5.40
WCF 4.5 Multi-Layer Services Development with Entity Framework Book Cover
WCF 4.5 Multi-Layer Services Development with Entity Framework
$ 29.99
$ 21.00
Entity Framework 4.1: Expert’s Cookbook Book Cover
Entity Framework 4.1: Expert’s Cookbook
$ 35.99
$ 25.20
Windows Presentation Foundation 4.5 Cookbook Book Cover
Windows Presentation Foundation 4.5 Cookbook
$ 35.99
$ 25.20
Visual Studio 2012 Cookbook Book Cover
Visual Studio 2012 Cookbook
$ 26.99
$ 18.90