BCS - External Database and Add/Edit/Delete Operations

Click on the Save button from the top tool bar:

4. Using SharePoint Designer create Lists & Form

Now the operations are ready and we need to create the List Form and the associated Add/Edit/Delete forms inside SharePoint.

From the toolbar, click on the Create Lists & Form button as highlighted above. In the dialog box enter the name for the list and click the OK button as shown below:

Wait for a while and your List page will be ready:

5. Using Central Administration set Permissions for external Content Type

Now you can try viewing the Customer Data list inside SharePoint.

On clicking the list, you will be seeing an "Access Denied by Business Data Connectivity" error message. To resolve this we need to set the permission for the External Content Type.

Open the SharePoint Central Administration website. Click on Manage Service Applications:



In the page click on the Business Data Connectivity Services link as shown below:

In the list, hover over the Customer Data item and click on the Set Permissions menu item as shown below:

You will get the following dialog:

Enter the user name, click the Add button and check all permissions. Click the OK button to close the wizard. (Make sure you are adding the username used to view SharePoint)
Now you are ready with the Permissions. Go back to the SharePoint > Customer Data list and you will be able to see the data as shown below.

Now you can try playing with the View/Edit/Delete features of the BCS list:

References

http://www.zimmergren.net/technical/access-denied-by-business-data-connectivity-solution

Summary

In this article we have seen how to create an External Content Type through Business Connectivity Services and view it inside SharePoint. In the real-world scenario using BCS we can connect to WCF Services and other Business Applications like Microsoft CRM to view/update data inside SharePoint.