Sharepoint Tutorials,Sharepoint 2010 Tutorials: Business Data Connectivity using SharePoint Designer 2010

Step 1) Open SharePoint Designer 2010, Then Open Site
in this example: http://sp2010:22913/sites/sc1
Once u opened site, click on External Content Types--> Then click on "External Content Type"(located in top left corner). as shown below,.

Step 2) Name External Content Type as MyCustomer, display name also same
Leave remaining things as default.

Click on "Click here to discover External ..."(as shown in 3rd arrow)

Step 3) Click on "Add Connection" --> "Select SQL-Server" as shown in the following figure,

Step 4) Enter ServerName(localhost) DataName(AdventureWorksDW2008R2) as shown below

Step 5) Select DimCustomers Table --> Right click on it.--> select "Create All Operations"

i.e CRUD--> Create,Read,Update& Delete.(else User can select individual actions, i.e only Read etc.,)

Step 6) The following figure shows all operations (user selected in Step 5)

Step 7) Save & Again click on "External Content Types"
The following figure will appear with External Content Type as "MyCustomer"

Step 8) Right click on "MyCustomer" select "External List"

Step 9) Enter External List Name as "MycustomerExt" and appropriate desc.. as shown below

Step 10) Goto Browser --> Click on "All Site Content"--> Under List --> MyCustomerExt will appear as shown below

Step 11) Goto "Central Administration"-->"Application Management"-->Service Applications(Click on Manage Service Applications"-->Click on "Business Data Connectivity Service"
The following screen will come up

Step 12) Select "MyCustomer" BCS --> Click on "Set Object Permissions"(The following screen will appear). Add "Administrator"--> click on Check Names--> Select all permissions Edit,Execute ... etc.,--> Click on OK button.