LINQ Fundamentals - Part 1

Introduction To LINQ

Language Integrated Query (LINQ, pronounced "link") is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages.  LINQ extends the language by the addition of query expressions, which are akin to SQL statements, and can be used to conveniently extract and process data from arrays, enumerable classes, XML documents, relational databases, and third-party data sources.

Standard Query Operators

Query Expressions

LINQ Extensibility

LINQ To Objects

Demo of Deferred Execution

LINQ To XML

Demo of Functional Construction via LINQ

Querying XML document

LINQ to SQL

Mapping objects to Tables

Demo of LINQ to SQL

Entity Framework

Note:

You may think that what is the difference between Entity Framework and LINQ to SQL which does that same thing. There are some differences between Entity Framework and L2S.

• Entity framework has a full provider model. It supports not only SQL Server but also other database like Oracle, DB2, MySQL etc.
• Most of the time L2S classes must be one-to-one with database objects e.g. Customer class can be mapped only with Customer table. Where as in Entity Framework you can map your domain class with multiple tables using various inheritance strategies like table per type (class) or table per hierarchy of classes etc.
• You can have multiple modeling techniques using Entity Framework 4.1 like code first, model first or database first.

LINQ and C#

Operators as Extension methods in LINQ

Functional programming with Lambdas

Named function as a parameter

Anonymous Method as parameter

Lambda expression as a parameter

Lambda Expression Essentials

Constructing Lambda Expressions

Invoking Lambda Expressions

Expressions

Note:  To execute Expressions, it should compile first and needs to be executed.

Expression Trees

Remoting LINQ

Query Expressions

Type inference

Anonymous Types

Initializers for Classes and Collections

Partial Methods

LINQ Queries

Query Expressions

Lambda Expression

Wrong WHERE Implementation

Right Custom WHERE Implementation

Deferred Execution Surprises

Greedy Operator in LINQ

The LET and INTO Keywords

Grouping in LINQ

Grouping and Projecting

Nested Queries

Correlated Sub-queries

Group Joins

Join with INTO keyword will make Grouping into Join result set.

Sorting

Composition

LINQ Pad Application usage

Standard LINQ Operators

Filtering

Sorting

Set Operators

Distinct

Equality in LINQ to Objects

Quantifiers

Projection Operators

Partitioning

Joining

Grouping

Lookups

Generation Operations

Equality

Element Operators in LINQ

Conversions

Blogger Labels: LINQ,Fundamentals,Introduction,Language,Query,Microsoft,Framework,component,data,capabilities,languages,addition,statements,databases,Standard,Operators,Expressions,Objects,Demo,Execution,Functional,Construction,Tables,Note,difference,differences,provider,Server,database,Oracle,MySQL,Most,Customer,Where,domain,inheritance,strategies,hierarchy,techniques,Extension,Lambdas,parameter,Anonymous,Method,Lambda,Expression,Essentials,Trees,Type,inference,Types,Initializers,Classes,Collections,Partial,Methods,Queries,Wrong,Implementation,Custom,Surprises,Greedy,Operator,INTO,Keywords,Group,Joins,Join,Composition,Application,usage,Distinct,Quantifiers,Projection,Lookups,Generation,Operations,Element,Conversions