current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

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.

share|improve this question
    
If you edit the create operation in SP Designer I think there is an option to uncheck the column as an input parameter which, if I recall correctly, will default it to not being an editable column on your external list new item/edit item form. If you are able to uncheck it but it shows up on the form as read-only, you can open up the new/edit forms in designer and hide the control. –  Jared McGrath May 14 '14 at 21:19
    
I figured it out - the stored proc which performs the insert needs to return the identity column. You can then map the return value to the ID column on the external list. –  Derek Evermore May 14 '14 at 21:33

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.