I am trying to get SQL database accessed and updated using SharePoint BDC and have following questions.
1. How to edit data in SharePoint list once it is fetched from SQL database?
2. Later can we add more fields to SharePoint list if needed?
3. How user permission will be remapped or updated? to ensure only user who is authorized is updating the SharePoint list?
4. Can we have two sync meaning if someone update the data on SQL using another ASP.net application and someone using SharePoint list? will both changes be seen on ASP.Net application as well SharePoint list?
5. Can we have versioning enabled on SharePoint list which is created through BDC process?