Best Practices

• Use any site template, including the Blank Site template, for creating external content types.

• Define associations for external content types that have relationships with others, such as the relationship between customers and orders.

• If using External Data columns in SharePoint lists, periodically click the Refresh icon to ensure that the most current data is displayed in your SharePoint lists.

• For simple databases with little or no logic on various columns or tables, SharePoint Designer may be a useful tool for creating write-back operations. However, for larger or more complex databases, use a more advanced tool, such as Visual Studio 2010 for building write-back operations.

• When including Create or Update operations ...

Get Microsoft SharePoint 2010 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.