Working with BCS and External List in SharePoint 2010

1.Create a table in SQL.
2.Open SharePoint designer. From the navigation pane select "External Content Types".
3.From the New tab in top ribbon click on "External content Type". Now your page will look like below screen.

4.Click on "New external content type" next to Name and enter the name.
5.Click on "Click here to discover external data sources and define operations” next to External System.
6.From Below screen click on "Add connection".
7.From "External Data Source Type Selection" choose SQL server. See Below screen.

8.In below screen enter local host in Database server, in database name, enter your db name.third field is optional.
9.Click OK.

10.Right click on table name and select "New Read Item Operation"

11.Click on “Next”
12.From below screen select your primary key and from properties pane, check the option "Map to identifier".

13.Do same in next page and click on Finish.
14.Again right click on Table name and select "New Read List Operation". And repeat the steps 11,12 and 13.
15.Open your SharePoint site.
16.From Site Action click on create list.
17.From list type select "External List". And click create.

18.Fill the details in respective input controls.

19.If you know the exact name then enter external source name in "External Content Type" which is last input in above screen and click OK.
20.Else click on 2nd icon next to "External Content Type" textbox. Below screen will open.

21.Select your external data source and click OK.
22.Again click on OK. Now your list will be populated on the screen. 
Protected by Copyscape


  1. Nice, looking forward to seeing these new posts especially with the scenario you’re building for SharePoint 2013 blogs!
    SharePoint 2013 Online Training


Post a Comment

Popular posts from this blog

CAML Query in SharePoint 2010

Calling REST APi from server side code - C#

All about SharePoint 2010 Content Type Hub

SharePoint Interview Questions and Answers

Calling ASP.Net WebMethod using jQuery AJAX