I have setup my SharePoint 2013 publishing site with BCS and Secure Store so that users can access multiple external lists within the site and if they have the correct permissions setup in Secure Store then they can edit the ECT's and it will update the SQL tables.

Here is my question though. If I create a 'View' in SQL and that view contains multiple columns from different tables within the database, can I create an ECT with that view, create an external list with the view, and have users modify it, and it will then update all the base tables within the View? I had thought I read somewhere that you cannot update multiple base tables using BCS, but can't seem to get a good answer.

Thank you!

1 Answer 1


You can use stored procedures for performing CRUD operations on data related to different tables. Check this for more information.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.