.Net 3.5 introduced a new techonolgy called Language Integrated Query or Linq(pronounced as "link")
LINQ includes three basic type of queries:
LINQ to Object;
LINQ to XML
and LINQ used in the context of database ,like LINQ to SQL or LINQ to ENTITES
LINQ to Object;
Example
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
/// <summary>
/// Summary description for Movie
/// </summary>
public class Movie
{
public string Title { get; set; }
public string Director { get; set; }
public int Genre { get; set; }
public int RunTime { get; set; }
public DateTime ReleaseDate{get;set;}
public Movie()
{
//
// TODO: Add constructor logic here
//
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
var mov = GetMovies();
var qu = new List<Movie>();
foreach (var m in mov)
{
if (m.Title =="Ram")
qu.Add(m);
}
GridView1.DataSource = qu;
GridView1.DataBind();
}
public List<Movie> GetMovies()
{
return new List<Movie> {new Movie {Title ="Ram", Director ="ABHI" ,Genre =0, ReleaseDate =DateTime.Parse ("05/12/2001"),RunTime =89},
new Movie {Title ="Gopal",Director ="Rohit",Genre =1,ReleaseDate =DateTime .Parse ("4/12/2002"),RunTime =96},new Movie {Title ="Ram",Director ="AMIT", Genre =1,ReleaseDate =DateTime .Parse ("04/12/2011"),RunTime =34}
};
}
}
Output:-
LINQ includes three basic type of queries:
LINQ to Object;
LINQ to XML
and LINQ used in the context of database ,like LINQ to SQL or LINQ to ENTITES
LINQ to Object;
Example
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
/// <summary>
/// Summary description for Movie
/// </summary>
public class Movie
{
public string Title { get; set; }
public string Director { get; set; }
public int Genre { get; set; }
public int RunTime { get; set; }
public DateTime ReleaseDate{get;set;}
public Movie()
{
//
// TODO: Add constructor logic here
//
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
var mov = GetMovies();
var qu = new List<Movie>();
foreach (var m in mov)
{
if (m.Title =="Ram")
qu.Add(m);
}
GridView1.DataSource = qu;
GridView1.DataBind();
}
public List<Movie> GetMovies()
{
return new List<Movie> {new Movie {Title ="Ram", Director ="ABHI" ,Genre =0, ReleaseDate =DateTime.Parse ("05/12/2001"),RunTime =89},
new Movie {Title ="Gopal",Director ="Rohit",Genre =1,ReleaseDate =DateTime .Parse ("4/12/2002"),RunTime =96},new Movie {Title ="Ram",Director ="AMIT", Genre =1,ReleaseDate =DateTime .Parse ("04/12/2011"),RunTime =34}
};
}
}
Output:-
Title | Director | Genre | RunTime | ReleaseDate |
---|---|---|---|---|
Ram | ABHI | 0 | 89 | 5/12/2001 12:00:00 AM |
Ram | AMIT | 1 | 34 | 4/12/2011 12:00:00 AM |
No comments:
Post a Comment