Using Linq in Sharepoint 2010

1. Mark sure you have sharepoint 2010 and visual studio 2010. Here, i installed sharepoint 2010 and vs2010 RC on my windows7 x64.

 

2. Create Products list in SP. the list contain 3 columns (Item, Nation, Price)

Item               Nation            Price

IPhone           US                   100

IPad               US                   800

E71                China               500

Moto              China               600

 

3. Create an empty sharepoint solution then add a visual webpart feature in it.

 

 

 

4. See the code

 

 ascx:

<div style="background-color:Yellow" mce_style="background-color:Yellow"> <table id="tblItems" runat="server"> </table> </div>

 

ascx.cs:

 

//Please add the reference under C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/ISAPI using Microsoft.SharePoint.Linq; // add other reference using System.Linq; using System.Web.UI.HtmlControls; // make a entity for your site. this is very convenience for you to build this, and then you can use this class to operate your site. // Go to the folder C:/Program Files/Common Files/Microsoft Shared/Web Server Extensions/14/BIN // create your own bat file and in the file, you can use SPMETAL.EXE command to generate your code. //example: SPMETAL /web:http://*********-pc:26292/ /code:d:/MyWebEntity.cs /language:csharp // then add this generated class to your project // from now on, you can start to use linq to operate the site content. public partial class LinqWebPartUserControl : UserControl { protected void Page_Load(object sender, EventArgs e) { MyWebEntityDataContext med = new MyWebEntityDataContext("http://geforcesong-pc:26292"); var products = from p in med.Products orderby p.Nation select p; foreach (var sp in products) { HtmlTableRow htr = new HtmlTableRow(); HtmlTableCell cl1 = new HtmlTableCell(); cl1.InnerText = sp.Nation; htr.Cells.Add(cl1); HtmlTableCell cl2 = new HtmlTableCell(); cl2.InnerText = sp.Price.ToString(); htr.Cells.Add(cl2); tblItems.Rows.Add(htr); } } }