LINQ Standard Query Operators in ASP.NET

March 14, 2014 0 Comments

The standard query operators are the methods that form the LINQ pattern. The standard query operators provide query capabilities including filtering, projection, aggregation, sorting, and much more. The standard query operator in LINQ is an Application Programming Interface (API) that enables querying of any .NET array or collection. You can use these standard query operators to operate on sequence.

The following are two set of standard query operators in LINQ:

1.  The first type is the one that operates on objects of the type IEnumerable<T>.
2.  The second one is the one that operates on object of the type IQueryable<T>.

The standard query operators differ in the time that they take for their execution. The time depends on whether they have to return a single value or a sequence of values. The methods that return a single value execute immediately. The methods that return a sequence of values reschedule the query execution and return an enumerable object.

List of all Query operators are:

Filtering Operator: Restricts the result set to contain those elements that satisfy a specific condition that are
Projection Operator: Transforms an object into a different type of new object
Sorting Operator:  Changes the order of elements of sequence returned by the query
Join Operator: Combines collections
Grouping Operator: Puts the data into groups
Quantifier Operator: Checks whether an element of a sequence satisfies a condition
Partitioning Operator: Returns a subset of collection
Set Operator:  Returns a result set which is in the form of a collection
Element Operator:  Returns just one element
Aggregate Operator:  Computes a single value from a collection
Conversion Operator: Converts the collection to an array
Generation Operator: Returns a new sequence of values

Jacob Lefore

Some say he’s half man half fish, others say he’s more of a seventy/thirty split. Either way he’s a fishy bastard. Google