Waht is LINQ?

Hi..

LINQ(Language Integrated Query) is the one of the Concept of object oriented programming and this is one of the feature added to the .net. LINQ is used to query the objects like listof models,Array,Datatable.
This is like SQL query here also we will use select, from, where, And, or and aggregate functions. But in dofferent way.

This is an example where i am using LINQ for the datatable:
'Datatable
Dim dt As New DataTable()

'Adding two columns Name and Age
dt.Columns.Add("Name", GetType(String))
dt.Columns.Add("Age", GetType(Integer))

'Adding Details
dt.Rows.Add("Asha", 20)
dt.Rows.Add("Usha", 10)
dt.Rows.Add("Ashok", 30)
dt.Rows.Add("Teju", 40)

'LINQ for datatable
Dim s = From detail In dt.AsEnumerable() Where detail.Field(Of Integer)("Age") > 20 Select detail
Dim dtOfAgeGre20 = s.CopyToDataTable

In the above example i am using LINQ to the datatable.dtOfAgeGre20 will store the data with the age>20.
Here i am using From in the beginning because we need to declare everything before usage in .Net, The conditios we will write in where clause and In is used to define the object to which we apply LINQ.

Thanks and Regards,
Asha.mp

Hi,

Check the following link for details
http://www.dotnetuncle.com/Articles%5CLanguage-Integrated-Query-LINQ.aspx