using System;

using System.Data;

using System.Data.DataSetExtensions;

​

using System.Collections.Generic;

using System.Data.Entity;

using System.Data.Linq;

using System.Linq;

public class Program

{

    public static void Main()

    {

       // User Set up       

       DataTable dt = new DataTable();  

       DataRow dr = null;  

       dt.TableName = "User";

       dt.Columns.Add("Id",typeof(int));  

       dt.Columns.Add("Name");  

       dt.Columns.Add("Age",typeof(int));   

       dr = dt.NewRow();  

       dr["Id"] = 1;  

       dr["Name"] = "Venky";  

       dr["Age"] = 23;  

       dt.Rows.Add(dr);  

       DataRow dr1 = null;  

       dr1 = dt.NewRow();  

       dr1["Id"] = 2;  

       dr1["Name"] = "Kamal";  

       dr1["Age"] = 24;  

       dt.Rows.Add(dr1);  

       DataRow dr2 = null;  

       dr2 = dt.NewRow();  

       dr2["Id"] = 3;  

       dr2["Name"] = "Kavya";  

       dr2["Age"] = 78;  

       dt.Rows.Add(dr2);

       DataRow dr3 = null;  

       dr3 = dt.NewRow();  

       dr3["Id"] = 4;  

       dr3["Name"] = "VenuG";  

       dr3["Age"] = 54;  

       dt.Rows.Add(dr3);

       IEnumerable<DataRow> query = from r in dt.AsEnumerable() select r;

       Console.WriteLine("User: ");

       foreach (DataRow p in query)

       {

         Console.WriteLine(p["Id"] + " "   + p["Name"]+ " "   + p["Age"]);

       }

       Console.WriteLine("");

         Console.WriteLine("Result:::");

       var q = from dataRows1 in dt.AsEnumerable()             

             select new

             {

                Id = dataRows1["Id"],

                Name = dataRows1["Name"],

                Age = dataRows1["Age"], 

                Concat =   dataRows1["Name"] + "_" + dataRows1["Age"] 

              };

​

foreach (var p in q)

{

    Console.WriteLine(p.Id + " " + p.Name + " " + p.Age+ " " + p.Concat);

}

    }

}