Skip to main content

Step by step BCS in SharePoint2010

Hi friends,
Through this blog I am going to share the e-Book on BCS in Sharepoint2010 which guide you in development for Business Connectivity Service in sharepoint2010.This books contains everything about BCS  with screens and real scenerio examples. Vijai Anand (Author of this e-book) have covered all possibles scenerio which required for BCS.

Below are the Contents in this e-book:

1 Business data connectivity services: an overview

2 Configure business data connectivity services
3 Configure BCS service application association

4 External content types

    4.1 SQL server database details

        4.1.1 Employee Details table

        4.1.2 Department table

        4.1.3 Relationship

    4.2 Create external content type using share point designer 2010

        4.2.1 Create External Content Type – Department ECT

        4.2.2 Create External Content Type Association – Employee Details ECT

    4.3 Create external content type using w cf service in share point designer 2010.

    4.4 Create external content type using visual studio 2010

        4.4.1 Create Business Data Connectivity Model

        4.4.2 Add LINQ to SQL Class

        4.4.3 Add Data Connections

        4.4.4 Delete the default Entity from the BDC Model

        4.4.5 Adding an Entity to the Model

        4.4.6 ReadItem (Specific Finder Method)

        4.4.7 ReadList (Finder Method), Create, Delete, Update

        4.4.8 Code Snippet

        4.4.9 Deploy the Solution

    4.5 Create external content type based on share point lists

        4.5.1 SharePoint List

        4.5.2 Create SharePoint Solution based on Business Data Connectivity Model template

        4.5.3 Delete the default BDC Model

        4.5.4 Create a new BDC Model

        4.5.5 Modify Entity1.cs

        4.5.6 Modify the Entity

        4.5.7 ReadItem (Specific Finder Method)

        4.5.8 ReadList (Finder Method)

        4.5.9 Add Service Reference

        4.5.10 Modify CustomersService.cs

        4.5.11 Deploy the solution

    4.6 Manage external content types

        4.6.1 Through Central Administration

        4.6.2 Using SharePoint Designer 2010

5 Configure business data connectivity access rights

    5.1 Set permissions for external content type through central administration
    5.2 Set permissions for external content type using power shell

6 BDC model

    6.1 View BDC models
    6.2 Delete the BDC model
    6.3 Export BDC model using sharepoint designer 2010
    6.4 Export BDC model through central administration 2010
    6.5 Import BDC model to BDC metadata store through central administration
    6.6 Export BDC model from BDC metadata store using powershell
     6.7 Import BDC model to BDC metadata store using powershell
     6.8 Remove BDC model from BDC metadata store using powershell

7 External lists

    7.1 Create external list through UI
    7.2 Create external list through sharepoint designer 2010
    7.3 Create external list using power shell

8 Crud operations for external data

    8.1 Create operation
    8.2 Read operation
    8.3 Update operation
    8.4 Delete operation

9 Configure external data column

10 Configure filter for external item picker using share point designer 2010

11 Search configuration for external data

    11.1 Create a new content source
    11.2 Create a new search scope
    11.3 Add scope rule
    11.4 Create a new basic search center
    11.5 Configure search scopes in the search center
    11.6 Start full crawl
    11.7 Search for external data

12 Configure profile page for BCS

13 Business data web parts

    13.1 Business data list
    13.2 Business data item

        13.2.1 Configure Business Data Item web part

        13.2.2 Configure connections between Business Data List and Business Data Item web part

    13.3 Business data actions

        13.3.1 Add an action to external content type

        13.3.2 Configure Business Data Actions web part

    13.4 Business data connectivity filter

        13.4.1 Configure business data connectivity filter

        13.4.2 Configure connections between business data connectivity filter and business data list web part

    13.5 Business data related list

        13.5.1 Configure Business Data List web part for Department External Content Type

        13.5.2 Configure Business Data Related List web part

        13.5.3 Connect Business Data List and Business Data Related List web parts

14 User profile imports using BCS

    14.1 Create new user properties
    14.2 Configure synchronization connection
    14.3 Add mapping to user property
    14.4 Edit the user profile
    14.5 Start full synchronization

15 Publish BCS across farms

    15.1 Exchange trust certificates between farms

        15.1.1 Exporting and copying certificates

   To export the root certificate from the consuming farm

   To export the STS certificate from the consuming farm

   To export the root certificate from the publishing farm

   To copy the certificates

        15.1.2 Managing trust certificates

   Establishing trust on the consuming farm

   Establishing trust on the publishing farm

    15.2 Publish BCS application

    15.3 Set permission to the application discovery and load balancing service application for a consuming farm by using windows power shell
    15.4 Set permission to the published service application for a consuming farm
    15.5 Connect to a bcs application on a remote farm

16 External data in Microsoft Word 2010

    16.1 Steps involved

17 External list in SharePoint workspace 2010

    17.1 SQL database details
    17.2 External content type
    17.3 External list
    17.4 Connect an external list to sharepoint 2010 workspace
    17.5 Crud operations on external list from sharepoint 2010 work space

        17.5.1 Read operation

        17.5.2 Create operation

        17.5.3 Delete operation

        17.5.4 Update operation

    17.6 Sorting, Grouping or Filtering external list items in work space

18 BCS related issues and how to resolve

    18.1 Access denied by business data connectivity
    18.2 Unable to add or edit the external list identifier column in the sharepoint workspace

    18.3 Unable to connect to the specified address. Verify the url you entered and contact the service administrator for more details

I am sure you will definetly like this book.

Thank you and enjoy sharepoint


  1. This paragraph is truly a good one it helps new web viewers, who are wishing in favor
    of blogging.
    Also visit my weblog : Ist ein Strompreisvergleich sinnvoll?


Post a Comment

Popular posts from this blog

SharePoint Branding Solution Pack using VS2010

Introduction Today, in this blog I am trying to provide you the Custom Branding solution Pack. This solution pack will save time and effort while developing the custom sharepoint with publishing sites in sharepoint. It works great. So, we all are good to go and use this re-usable solution pack. Description The source code shows how to prepare a structure for Sharepoint Branding solution. This pack contains : Master Page Gallery structure Page Layout Gallery structure Image Gallery Styles Library gallery Event Receiver

Create Custom hit counter in SharePoint2010 using Sandbox Solution

In this blog I am going to demonstrate how to create Hit counter for SharePoint site with user details using sandbox solution. I took reference from codeplex code( ) which is sharepoint2007. I modified his sample and tried make it simple and easy for you. Once you understand the way I created then its very simple for you to make any further modification depends on your requirement. This solution will be very useful when you need detail about the person who visit this page and also about the number of time page view with page detail. I created this solution that will make your work easy. It's very simple where you don't need to do anything except deploying the feature and adding the web part into you master page or layout page in sharepoint2010. Below is the screenshot that will display the how it looks like:

Create a Web Part Page with a Web Part in Sharepoint 2010

Source code from codeplex In this blog I am going to explain how to create a web part page along with a web part. After using this feature, we just need to activate the feature; the rest will complete automatically. Steps for creating the functionality: Step 1: Create a project with Farm-Based solution: Step 2: Add a new item as webpart: Step 3: Add feature event receiver class, your solution should look like the following: Step 4: Add your logic to the web part: 01 [ToolboxItemAttribute( false )] 02 public class CustomWebPart : WebPart 03 { 04 protected override void CreateChildControls() 05 { 06 LiteralControl lt = new LiteralControl(); 07 lt.Text = "This webpart automatically added with page" ; 08 this .Controls.Add(lt); 09 } 10 } Step 5: You need to provide logic in the feature Reciever class. Find the attached file to see the source code. Step 6: Build, deploy and activate the feature. Step 7: Go to Page library ( S