I have a SQL table (with a primary key identity column) which I want to perform CRUD operations on using a SharePoint external list as a front end. I have setup stored procedures to perform the CRUD operations. I have been able to setup an external content type with Read Item, Read List, Update Item, and Delete Item operations.
I am having an issue with the Create operation. The identity column value gets set automatically when a row is inserted into the table. When I try to setup a Create operation on the external content type it wants the identity column to be explicitly specified by the user. I don't want the user to specify this identity - I want to to be automatically handled by SQL server when the new row is inserted.