4.1 SQL server database details
4.1.1 Employee Details table4.1.2 Department table4.1.3 Relationship
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 ECT4.2.2 Create External Content Type Association โ Employee Details ECT
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 Class4.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 Snippet4.4.9 Deploy the Solution
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 template4.5.3 Delete the default BDC Model4.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 Reference4.5.10 Modify CustomersService.cs4.5.11 Deploy the solution
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 Administration4.6.2 Using SharePoint Designer 2010
4.6.1 Through Central Administration
4.6.2 Using SharePoint Designer 2010
5.1 Set permissions for external content type through central administration5.2 Set permissions for external content type using power shell
6.1 View BDC models6.2 Delete the BDC model6.3 Export BDC model using sharepoint designer 20106.4 Export BDC model through central administration 20106.5 Import BDC model to BDC metadata store through central administration6.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.1 Create external list through UI7.2 Create external list through sharepoint designer 20107.3 Create external list using power shell
8.1 Create operation8.2 Read operation8.3 Update operation8.4 Delete operation
11.1 Create a new content source11.2 Create a new search scope11.3 Add scope rule11.4 Create a new basic search center11.5 Configure search scopes in the search center11.6 Start full crawl11.7 Search for external data
13.1 Business data list13.2 Business data item
13.2.1 Configure Business Data Item web part13.2.2 Configure connections between Business Data List and Business Data Item web part
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 type13.3.2 Configure Business Data Actions web part
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 filter13.4.2 Configure connections between business data connectivity filter and business data list web part
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 Type13.5.2 Configure Business Data Related List web part13.5.3 Connect Business Data List and Business Data Related List web parts
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.1 Create new user properties14.2 Configure synchronization connection14.3 Add mapping to user property14.4 Edit the user profile14.5 Start full synchronization
15.1 Exchange trust certificates between farms
15.1.1 Exporting and copying certificates
15.1.1.1 To export the root certificate from the consuming farm15.1.1.2 To export the STS certificate from the consuming farm15.1.1.3 To export the root certificate from the publishing farm15.1.1.4 To copy the certificates
15.1.1.1 To export the root certificate from the consuming farm
15.1.1.2 To export the STS certificate from the consuming farm
15.1.1.3 To export the root certificate from the publishing farm
15.1.1.4 To copy the certificates
15.1.2 Managing trust certificates
15.1.2.1 Establishing trust on the consuming farm15.1.2.2 Establishing trust on the publishing farm
15.1.2.1 Establishing trust on the consuming farm
15.1.2.2 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 shell15.4 Set permission to the published service application for a consuming farm15.5 Connect to a bcs application on a remote farm
16.1 Steps involved
17.1 SQL database details17.2 External content type17.3 External list17.4 Connect an external list to sharepoint 2010 workspace17.5 Crud operations on external list from sharepoint 2010 work space
17.5.1 Read operation17.5.2 Create operation17.5.3 Delete operation17.5.4 Update operation
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.1 Access denied by business data connectivity18.2 Unable to add or edit the external list identifier column in the sharepoint workspaceProblem:18.3 Unable to connect to the specified address. Verify the url you entered and contact the service administrator for more details