SharePoint uses BCS to develop your first application (3)

SharePoint uses BCS to develop your first application (3) to create external content types. There are three different types of external content to be created: 1. Write the XML code on the notepad (not recommended ). 2. Create using SharePoint designer 2010 (recommended ). 3. Use vs (requires rich programming experience ). If you use SharePoint designer to create an external content type, it automatically saves the XML Metadata to the BDC business data connection metadata repository and presents it in the management center. Vs creates a standard WSP for the BDC metadata project so that the XML Metadata File is deployed to the correct location. If you create an XML Metadata file that you love outside SharePoint designer or VS, open the Management Center-Application Management-managed service application-Business Link Service and click Import. This section teaches you how to create External content type based on ADO. net . External content types are necessary. You can create relationships between external data sources and applications. 1. Open SharePoint designer 2010.2. Click file to open the site. 3. Click the external content type. 4. Click the external content type of the functional area. 5. Name mycustomers and display customers. 6. Select a contact in the office project type. 7. Make sure that offline synchronization is enabled. 8. Click "here to discover external data sources ". 9. Click Add connection-SQL server data type. Enter the corresponding content, and the database name adventureworkslt2008. select "Connect with user ID ".

10. Browse the MERs table and right-click to select create all operations.
11. This will call a wizard to map columns of external data sources to the office project type and create filters for data. 12. Click Next. Next you will map some Data Source Elements on the left to office properties. For example, click lastname and select lastname from the drop-down list on the right. Then select the title, firstname, companyName, emailaddress, and phone elements. Note that not all elements can be mapped. You can set these as custom attributes. 13. Click Next to add a data filter. This is not required. Click Finish. 14. Click Save. 15. Create an external class table accordingly. Click the list and form of the created functional area, name my MERs, and clear the create infopath form check box by default.
16. SharePoint designer now creates an external list. You can preview on a Sharepoint site. 17. You may find that your list displays "Access Denied" information. This is because you do not have the permission. Close the site, go to the management center, click Application Management -- manage service applications -- business data connectivity -- my customers -- set object permissions. In the Add account area, enter all authenticated users, click Add. Select all permissions. Click OK. 18. Try editing a list item and return to SQL Server to view it. The data is updated at the same time.