Why We Use LINQ in C# Specific answer ?

Question

Why We Use LINQ in C# Specific answer ? Thank You Blog: http://aspnettutorialscode.blogspot.in/

Rahul Singh · Answer

Hi Saber, Language Integarted Query( LINQ ) was introduced in C# 3.0 & .NET framework 3.5 , the idea behind this was, suppose some day we are working on SQL server database so we need to learn SQL server syntax, Sql related ADO.NET objects. Now suppose after some time we switched to a Oracle database , so again we need to garb command on oracle related syntax & oracle related ADO.NET objects to work with C#, so basically this problem arises with the number of technologies we adapt, we need to learn all of them. So basically to avoid this, Microsoft introduced LINQ where we can not only work with collections populated from database, but with various other data sources as well like XML file, a in-memory datatable etc. We can even use LINQ when working with Reflections . In .Net any datasource which implements IEnumerable interface can be used for querying, filtering, grouping, ordering & projecting data. We can use LINQ queries in two ways:- 1. Query Syntax 2. Methos Syntax Many times we use a combination of both. Now, with the evolution of entity framework the imporatnce of LINQ has grown much much higher as compared to old times.

Priti Kumari · Answer

(1)Using LINQ you can querying any datasource data for example you can querying data of oracle,sql,mysql ,XML etc.there is not required to know about every database query language if you are C# programmer only.

Saber Shaikh · Answer

Thank You