Hi everyone

With the release of .NET framework 3.5, Microsoft introduced lots of new features. One of the very important feature introduced is LINQ, which stands for Language Structured Integrated Query. I have been studying LINQ since the last 2 months and I find it an excellent approach to data management. In this post, I will give a brief overview about it.

While writing a software, at some point of time we write code which deals with data. The data can be in any form; files stored locally on a computer, tables in a database or even XML documents. While dealing with data when we are creating applications using .NET, at times we may have to carry objects to a database and then load the results back to the object after querying the database.

The following pseudocode will explain this approach.

Students Stu = New Students();   // A class which represents a table of students
Stu.stuID = 5;  // Setting the row identifier to 5
Stu.Retrieve();   // Retrieving Row’s data where Student ID = 5
Stu.Name = “Pushkar Arora”;   // Changing the column ‘Name’ value to Pushkar Arora
Stu.Update();   // Updating the Database data

A real cool and simple approach, isn’t it? Now to implement this, in ADO.NET we do the following. (more…)