Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

Creating External Content Types: Best Practices

SharePoint 2010

Last modified: April 16, 2010

Applies to: SharePoint Server 2010

When creating external content types, be aware of the following best practices:

  • It is strongly recommended that you add a limit filter to an external content type based on a database to limit the number of rows coming from the database.

  • In a production environment, it is likely that your database and SharePoint Server are on two different physical computers. In such a case, you should use the Secure Store Service to store your credentials to resolve the double hop problem.

  • Always define at least a Read List method and Read Item method for your external content type. Other Microsoft Business Connectivity Services (BCS) presentation features such as external lists rely on these method instances.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.