I used SharePoint Designer 2010 to create an external content type (ECT) that consumes and writes data to SQL Server. [Went through the process of connecting to a database table, then right-clicking the table created All Operations. Published to Sharepoint and everything is working well.
Now I am required to modify the original database, which is to add an additional field. After adding the new database field I need a way to be able to REFRESH my entire BCS so that the new field from the database shows up on the on the Create, Read Item, Update, Delete, and Read List form. Inside each operation I’ve checked off the new field to be included in the operation, clicked finish and saved. In the SharePoint site I opened the Modify View tab and included the new field and it does display correctly. However, I’ve found that when I go to create or update an item that field does not show.
How can I get these fields to propagate throughout SharePoint in their respected operations? I would hope there would be a way to do this without recreating the ECT. I haven’t tried this yet might attempt soon.