Creating External Content Types: Best Practices

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.