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…)