Understanding LINQ in One-Liners

Here I will provide one liner-explanations of terminology used with LINQ.

From: initialize a data source just like we declare a variable first before using it in C#.
where: applies a condition in a LINQ query.
select: selects a value from the LINQ query.
var: assigns a variable for when we don't know the return type of our LINQ query.
Deffered execution: the LINQ query will store only the information, it will not provide the result directly to you. To get the result you need to use a foreach loop or toList or ToArray method. Until this stage LINQ is in the deffered execution stage.
foreach loop: to iterate the result that we got from the LINQ query and then to execute the result.
IEnumerable<string>: use this if you know that your LINQ query return type will be a string and the data is in your in-memory.
IQueryable<string>: use this if the query is generated using a database.
Lambda expression: use the => operator if you are using a method-based LINQ query. The left hand of the => operator is the input and the right hand side is the output.
Expression lambda: use an expression lambda if you want to pass an expression on the left hand side of the => operator.
Statement lambda: If you want to use a statement in the right hand side of the => operator then use the statement lambda enclosed in brackets {}.
Async Lambda: use this if you want to use async or await in your LINQ query.
Async and await: to do asynchronous programming like if one resource is busy then the other program will keep executing, it will not wait for completion of the resource task.
let: use the let keyword when you want to store the result of any expression inside the LINQ.
LINQ to SQL: use this if you want to access a collection from a SQL Server in your in-memory.
System.Data.Linq.dll: add this DLL if you want LINQ to SQL.
insertonsubmit: use this when you want to insert data into SQL using LINQ to SQL.
deleteonsubmit: use this when you want to delete data in SQL using LINQ to SQL.
submitchanges: use this in LINQ to SQL after insertonsubmit or deleteonsubmit or if you have updated any data in your in-memory collection. This will submit your data finally to the database.
LINQ to dataset: use this if you want to query your in-memory dataset.
System.Data.DataSetExtensions: use this DLL if you want to use LINQ to a dataset.
asenumerable: use this if you want to apply LINQ to a datatable since a datatable doesn't implement ienumerable or iqueryable.
field: use the field method in LINQ to access a datatable column using LINQ to dataset.
setfield: use SetField if you want to set column values in a DataRow using LINQ to dataset.
isnull: use isnull if you want to check that a column is null or not using LINQ to dataset.
join: use this if you want to join two datatables using LINQ to dataset.
groupjoin: use this when you want a superset of inner joins and left outer joins.
LINQ to Objects: use this if you want to apply the LINQ on an array, list or dictionary.
LINQ to XML: use this if you want to do manipulation with XML or if you want to create new XML using LINQ.
Distinct: use this with your LINQ query if you want to remove duplicate values from a collection.
Except: use this with LINQ if you want to return the set difference of two collections.
Intersect: use this if you want to return common data from two collections in LINQ.
Union: use this when you want all elements from both collections but the result should not contain duplicate data.
All: use this in LINQ if you want to check that your condition is satisfying all the elements of a collection.
Any: use this in LINQ if you want to check your condition with any element in a collection.
Contains: use this if you want to check whether or not a sequence contains a specified element.
Skip: use this if you want to skip elements up to a specified position in a sequence.
SkipWhile: use this if you want to skip elements until the condition is true.
Take: use this if you want to take the first n elements from a sequence.
Takewhile: use this if want to take all the elements when the condition becomes true.
concat: use this if you want to combine two sequences, it may contain duplicate values also.
AsQueryable: use this if you want to convert a generic Ienumerable type to a generic IQueryable Type.
Cast: use this if you want to cast an element of a sequence in any other type.
ToArray: use this if you want to convert your collection into an array and if you want to force query execution.
ToDictionary: use this function if you want to put your element into a dictionary based on key. This will also force query execution.
ToList: use this if you want to convert collections into a generic list. This will also force query execution.
ToLookup: this is also like a dictionary but with a one-to-many relationship. Use this if you want to put your element into a dictionary.

16 Comments

Join the conversation! Your thoughts help the community grow.

Venkat Mungari10y ago
Nice article
Subash10y ago
Simple and easy to understand
Sonu Chaudhary10y ago
Good one...
Bhuvanesh Mohankumar10y ago
Good one...
Tony Yang10y ago
beautiful
Dashang Makwana11y ago
Madhuri u hav any contact?
Madhuri Mishra11y ago
thanks :)
Umamaheswara Rao Dasari11y ago
Super...
Ehsan Sajjad11y ago
very nice article.. impressed
niraj niyanta11y ago
good article
Madhuri Mishra11y ago
Thank u all :)
Nitin11y ago
good one
Venkat Mungari11y ago
Thanks for useful information
Rahul Kumar Saxena11y ago
Good Show...
Dashang Makwana11y ago
@madhuri u know advance sql concept ? things above just joins .. and CRUD queries in sql server
Shehzad11y ago
Thanks for compilation