Course info

Rating

(2037)

Level

Intermediate

Updated

Oct 26, 2008

Duration

4h 50m

Description

Language Integrated Query (LINQ) introduces fundamental changes to the techniques .NET developers will use to access data. LINQ brings general-purpose query facilities to the .NET framework and allows a developer to query data inside of in-memory objects, data inside of relational databases, and data inside of XML using a uniform API and syntax. This course will cover the basics of working with LINQ and C#.

About the author

Scott has over 15 years of experience in commercial software
development and is a frequent speaker at national conferences,
and local user groups. Scott is a Microsoft MVP and has authored
books on several Microsoft technologies, including ASP.NET, C#,
and Windows Workflow.

Section Introduction Transcripts

Introduction To LINQHi. This is Scott Allen of Pluralsight and this module is an introduction to LINQ. This is the first module in a series of modules that'll guide you through LINQ and LINQ-related technologies. In this one, we're going to just give you an overview of LINQ, which is Language Integrated Query. Specifically, we're going to be talking about why do we have LINQ, what sorts of problems will it solve. We're going to look at our first couple LINQ queries and we're going to go through a summary of the major LINQ technologies which includes LINQ to Objects to query, things that are in memory. LINQ to XML, that'll let us query XML documents and also create XML documents. We'll look at LINQ to SQL which is-- allows us to use LINQ to Query the database. And we'll take a quick look at LINQ to Entities, which allows us to define an entity data model for our database and use LINQ to query that entity data model.

LINQ And C#Hi, this is Scott Allen on Pluralsight and this module is C# and LINQ. In this module we're going to be looking at how the C# language has evolved to support language integrated query So, we're going to start off by talking about Extension methods, Lambda Expressions and Expression Trees. And then we're going to look at 2 ways to write LINQ queries in C#. The first syntax is what we call the Link Comprehension Query Syntax and the second syntax is often referred to as the Extension Method Syntax. And some people alSo, refer to it as the Lambda Expression Syntax. And then we'll wrap this up by looking at some features that make LINQ more enjoyable and C# and that is type inferencing Anonymous Types and Partial Methods.

LINQ QueriesHi. This is Scott Allen of Pluralsight and this module is Queries with LINQ. This is the third module in a series of modules that cover Language Integrated Query and its related technology. In this module, we're going to be looking specifically at queries that use the, mostly the comprehension query syntax which we've talked about in earlier modules. That's the syntax that looks a bit like structured query language. We're going to drill into the anatomy of these queries, talk about the sequences, talk about how deferred execution is actually implemented, and then look at how to do selecting, filtering, grouping, and joins. Those operators are all available in the comprehension query syntax. And then we're going to take a look at a couple advanced topics like composing queries. That is the ability to define a query in a low level of our architecture, let that query bubble up and we'll keep adding to it and compose additional operators into that. And we'll also look at building dynamic queries on LINQ.

The Standard LINQ OperatorsHi. This is Scott Allen of Pluralsight. And in this module we're going to cover the Standard LINQ Query Operators. The standard operators are the little pieces of functionality that actually make LINQ work. You can roughly categorize these operators into the groups that we see on the slide. And we've seen some of these operators before. For instance, we've seen the Where operator, that's a filtering operator. We've seen the Select operator, that's a projecting operator. And we've done some Joining and Ordering and Grouping, but we're also going to look at some other things in this module to talk about how to do Conversions, how to do some Set-based operations, Aggregation, and Quantifiers, Generation, and Element selection.