Linq on data table

Below is the code to read the data from data table using linq.

You cannot directly use the data table as you use collection object and specify the linq expression. For data table you need to convert its content which represent collection using AsEnumerable() method.

Example:

var Data = (from p in yourDataTable.AsEnumerable() Select p

 

Advertisements

#linq-on-data-table

What is LINQ?

Language-Integrated Query (LINQ) is a set of features introduced in Visual Studio 2008 that extends powerful query capabilities to the language syntax of C# and Visual Basic.

LINQ Architecture

Programming Languages  >> .Net Language Integrated Query >> LINQ Enabled Data Sources

Where

Programming Language can be C#, VB.Net and Others.

LINQ Enabled Data Source can be Objects, Relational (Datasets, SQL and Entities) and XML.

#language-integrated-query, #linq