LINQ Sample (LINQ as DataLayer)

Steps to connect Linq with asp.net

Open Sqlserver , I am using 2005 version . Create a sample DB named as “Sample”

Create a Table named as “Countries”

Insert some data into the Countries

Open Visual studio 2008 . Create a new Asp.net Project name as “LinqSample”

Choose Project , Right Click add new “Linq to Sql Classes” name it as “Linq” , this will create a new dbml file .

From Tools Choose View --> Server Explorer ,
Connect to Database ,
Choose DataSource ,
Select SqlServer

Select Database

Drag & Drop “Countries” Table into the Designer (inside Dbml file) .

Open Default.aspx Designer , Drag & Drop Gridview DataControl on to the Page

Open Default.aspx.cs , Add the below code .

protected void Page_Load(object sender, EventArgs e)
{
LinqDataContext context = new LinqDataContext();
GridView1.DataSource = context.States.ToList();
GridView1.DataBind();
}