Creating External content type with CRUD operations using Business Data Connectivity Model in ShareP


Business Connectivity Services (BCS) is a new service introduced with SharePoint 2010 to allow SharePoint sites to connect to and manipulate external data. SharePoint 2007 had a similar facility in the form of Business Data Catalog (BDC) which made external data available within its site. However, a major problem with BDC was the difficulty in creating solutions as there was no support in the 2007 designer.  Most BDC solutions were simply for accessing external data, manipulating external data sources was extremely difficult.

With SharePoint 2010, BCS ships with out-of-box features such as solutions, services, and tools which make connecting to external data an easy task. Whether you want to retrieve Outlook contacts in a list offline or edit the contents of your document file or share your excel sheet online or reuse data from dynamic InfoPath forms or just update your business presentation, BCS enables deep content sharing, editing and integration in SharePoint 2010 with SharePoint Designer and Visual Studio tools. In this article, we are going to create a model for the BDC service that returns information from a SQL database. You will then create an external list in SharePoint by using this model.

Steps Involved:

  1. SQL Database.

  2. Create Business Data Connectivity Model.

  3. Add LINQ to SQL class.

  4. Removing the default Entity from the BDC Model.

  5. Adding an Entity to the Model.

  6. CRUD Operations.

  7. Configure Business Data Connectivity access rights.

  8. Creating External List.

  9. Testing.