LINQ

Category: Academics

Over the last few months I wrote a few blogs about different languages and their specific features. Today, we will discuss about inserting or modifying data in database, which is an important part of business in various fields. For modifying data firstly we require to connect to database. In C#, you can create connection with the help of ADO.Net, LINQ and OLEDBC etc. But for now we will only discuss about LINQ, which stands for .Net Language Integrated Language, Which is a query operator used in web pages to retrieve and modify data either from the database or withXML file. It applies the principle of Object Oriented Programming to relational data. In Relational data like Select, Join, Group, Partition, Set Operation are implemented in LINQ. LINQ offers compact, the Expressive and intangible syntax for manipulating data. It uses SQL like syntax to make query expression. It Provide two sets of Standard query operator on objects of type IEnumerable and another set to operate on object type IQueryable. LINQ enables you to communicate with a different data source. Query expressions consist of three clauses that are from, where and select. The query variable it doesn’t take any action and without returning data. It stores the information that is required to produce the results for when the query is executed.