SPMetal LINQ - To SharePoint 2010 Programmatically Using VS 2010

Introduction

 

Today, in this article let's play around with one of the interesting and most useful concepts in SharePoint 2010.

Question: What is a SPMetal LINQ to SharePoint Select?

 

In simple terms "It enables creation of a DataContext object using SPMetal, by which we can access the list data with the help of LINQ query and bind it up to the grid".

 

I think we are now good to go and implement this wonderful concept.

 

Step 1: Open the command prompt as an administrator and enter the following command by requesting a specific site:

 

Spmetal.exe /web:http://win-5d57sl2rvt1:9107/ /code:C:\Student.cs

 

After you have run this, Student.cs file will be created the in the C: Drive of your system directories.

 

Step 2: Open SharePoint 2010 Central Administration and navigate to a specific site.

 

Step 3: Open up Visual Studio 2010 and try to create an empty SharePoint project:

 

 

 

Step 4: Select "Deploy as a farm solution" and click the "Finish" button. Now an empty project will be created.

 

 

Step 5: Add a new visual webpart for that project. Also add the Student.cs file into the project.

 

 

Step 6: The complete code of visualwebpart1usercontrol.ascx looks like this:
 

<%@ Assembly Name="$SharePoint.Project.AssemblyFullName$" %>

<%@ Assembly Name="Microsoft.Web.CommandUI, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"

    Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="Utilities" Namespace="Microsoft.SharePoint.Utilities" Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@ Register TagPrefix="asp" Namespace="System.Web.UI" Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" %>

<%@ Import Namespace="Microsoft.SharePoint" %>

<%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages"

    Assembly="Microsoft.SharePoint, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

<%@  Control Language="C#" AutoEventWireup="true" CodeBehind="SPSelectWPUserControl.ascx.cs"

    Inherits="SPMetalSelectApp.SPSelectWP.SPSelectWPUserControl" %>

<center>

    <div>

        <table>

            <tr>

                <td colspan="2">

                    <asp:label id="Label1" runat="server" text="LINQ-TO-SharePoint Select - SharePoint 2010 Programatically"

                        font-bold="true" font-size="Large" font-names="Verdana" forecolor="Maroon"></asp:label>

                </td>

            </tr>

            <tr>

                <td colspan="2">

                    <br />

                    <asp:button id="Button1" runat="server" text="Show List Data" font-names="Verdana"

                        width="282px" backcolor="Orange" font-bold="True" onclick="Button1_Click" />

                </td>

            </tr>

            <tr>

                <td colspan="2" align="center">

                    <br />

                    <asp:gridview id="GridView1" runat="server" backcolor="LightGoldenrodYellow" bordercolor="Tan"

                        borderwidth="1px" cellpadding="2" enablemodelvalidation="True" forecolor="Black"

                        gridlines="None" autogeneratecolumns="False"><AlternatingRowStyle BackColor="PaleGoldenrod" /><FooterStyle BackColor="Tan" /><HeaderStyle BackColor="Tan" Font-Bold="True" /><PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" /><SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" /><Columns><asp:BoundField DataField="Id" HeaderText="Person Id" ReadOnly="true" SortExpression="Id" /><asp:BoundField DataField="Title" HeaderText="First Name" ReadOnly="true" /><asp:BoundField DataField="LastName" HeaderText="Last Name" ReadOnly="true" /><asp:BoundField DataField="Gender" HeaderText="Gender" ReadOnly="true" /><asp:BoundField DataField="Age" HeaderText="Age" ReadOnly="true" /></Columns></asp:gridview>

                </td>

            </tr>

        </table>

    </div>

</center>

Step 7: The complete code of visualwebpart1usercontrol.ascx.cs looks like this:

 

using System;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using Microsoft.SharePoint.Linq;

using System.Linq;

namespace SPMetalSelectApp.SPSelectWP

{

    public partial class SPSelectWPUserControl : UserControl

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            StudentDataContext dataContext = new StudentDataContext("http://win-5d57sl2rvt1:9107/");

            var select = from r in dataContext.PersonList select r;

            GridView1.DataSource = select;

            GridView1.DataBind();

        }

    }

}
 

Step 8: Deploy the solution file and add the created webpart to SharePoint site.

 

 

Step 9: The output of the person list looks like this:

 

 

 

Step 10: The output of the application looks like this:

 

 

 

 

 

I hope this article is useful for you.