Background: There is requirement of calling external list from SQL to SharePoint 2013. We have done it using BCS, external content Type and SecureStore. There are also some modification done using InfoPath forms to view external list data more user friendly.
Tools Used: SharePoint Designer to create external content type
Problem: When there is change in list structure of SQL database table, external lists are no longer working and we have to follow external content type and external list creation process. Moreover, modification in InfoPath as well.
- If there is any way to create external content type dynamically, that we can handle using Feature activation. (Farm Scoped)
- Creation of external content type dynamically using SharePoint App model. (App Scoped) <-- Preferred
- What is possible way for handling this situation dynamically?
- Has anyone real world experience for similar situation where it need to be flexible with SQL table structure while creation of external list. And external content type / list adopts new structure dynamically, if there is any change at database level [SQL table structure, no. of columns, column type etc]
Any help or suggestions would be highly appreciated.