Just make sure your Read List and Read Item operation in your ECT have the same fields

Had some fun during the weekend. Customer asked me to add 3 new fields to an existing External Contents Type hosted on a SharePoint 2010 farm. Simple right? SQL Server Modify the pre-production database and alter the table to create 3 new varchar fields Add some dummy content to some records in pre-production farm SharePoint Designer Open the pre-production site collection and locate the External Content Type Open the external content type look at the operations and update the fields including the new ones After saving the changes I proceeded to test, and got an error, the view was not … Continue reading Just make sure your Read List and Read Item operation in your ECT have the same fields

BCS Limitatios to keep in mind

Have you wonder about the limitations of BCS in SharePoint 2010? Well¬†Chakkaradeep Chandran a Program Manager from Microsoft SharePoint Development Team blog about it here on August 2010.¬†As long customers require SharePoint 2010 support I will continue sharing information like this. So, please take a look: BCS Limitations Even though BCS is great and can do wonders when you want SharePoint 2010 to interact with your external systems or other LOB applications, it has its own limitations. Understanding these limitations will help you build good BCS solutions. Below are some/all of the BCS/External Lists limitations: Workflows cannot be associated with … Continue reading BCS Limitatios to keep in mind