I need to get the ID for an inserted row back from the database. I have done this in EF with stored proc mapping and setting the result binding, I am using INSERT WITH RETURNING clause for my stored procedure. Execution of this end up with the error below. I tried doing the same with a SQL Server stored procedure and it works like a charm.
The data reader is incompatible with the specified 'CSRModel.TESTTABLE'. A member of the type, 'ID', does not have a corresponding column in the "data reader with the same name.."
Has anyone successfully mapped an oracle insert stored procedure in the EF designer if so could you please post the oracle stored procedure used for the insert.