There are a number of features that are missing when you create an External List based on an External Content Type. This can cause a lot of issues with end users because even though it looks exactly like a normal list it might not behave exactly like a normal list (or at least have some features missing)
Those are,
1. Workflows cannot be associated with external lists
2. Cannot create Information Management Policies
3. LINQ to SharePoint spmetal.exe does not support external lists
4. No Check In, Check Out. so No versioning.
5. No Inline Editing or Datasheet View
6. No ratings
7. No alerts
8. No attachments
9. No REST access through ListData.svc to External Lists
10. No RSS Feeds
11. No Item Level Permissions
12. No item or field level validation
13. No Lookups
14. No ability to Export to Excel, Create Visio Diagram, Open with Access or Open with Project.
15. Cannot use SharePoint Content Types.
16. No Managed Metadata columns for ECT
Thanks! SharePoint External Lists (BCS) has still more limitations. This one lists them:
ReplyDelete25 Limitations of External Lists in SharePoint 2010