LINQ Query Operations

Go Back

Level : Intermediate

Go Back

Mentor: Shailendra Chauhan

Duration : 00:02:00

Get Details

Filtering Operators

Filtering operators are used to select elements from a data source that meet specific criteria.

Example

var filteredData = data.Where(item => item.Age > 25);

Join Operators

Join operators combine elements from multiple data sources based on a common key.

Example

var result = from employee in employees
join department in departments on employee.DepartmentId equals department.Id
select new { employee.Name, department.DepartmentName };

Projection Operations

Projection operators are used to transform the elements of a data source into a new form.

Example

var projectedData = data.Select(item => new { item.Name, item.Age });

Sorting Operators

Sorting operators are used to order elements in a data source based on specific criteria.

Example

var sortedData = data.OrderBy(item => item.LastName);

Grouping Operators

Grouping operators group elements in a data source based on a common key.

Example

var groupedData = data.GroupBy(item => item.Department);

Conversions

Conversion operators are used to change the type of elements in a data source.

Example

var convertedData = data.Cast<string>();

Concatenation

Concatenation operators combine two or more sequences into a single sequence.

Example

var concatenatedData = data1.Concat(data2);

Aggregation

Aggregation operators perform calculations on a sequence, such as calculating the sum or average.

Example

var sum = data.Sum(item => item.Amount);

Quantifier Operations

Quantifier operators check if elements in a sequence satisfy a specified condition.

Example

var anyAdults = data.Any(item => item.Age >= 18);

Partition Operations

Partitioning operators split a data source into multiple partitions or chunks.

Example

var partitionedData = data.Skip(3).Take(5);

Generation Operations

Generation operators create a sequence of values, such as a range of numbers.

Example

var numbers = Enumerable.Range(1, 10);

Set Operations

Set operators perform set-based operations like union, intersection, and difference on sequences.

Example

var unionResult = data1.Union(data2);

Equality

Equality operators compare two sequences for equality based on their elements.

Example

var areEqual = data1.SequenceEqual(data2);

Element Operators

Element operators retrieve specific elements from a sequence.

Example

var firstItem = data.First();

Self-paced Membership

Upto 60% OFF

Know More

Still have some questions? Let's discuss.