This content has been marked as final. Show 3 replies
There is an existing bug 12630958 for this issue.
As a workaround, you may create a custom INSERT stored procedure using XMLTYPE parameter.
Include this stored procedure in your data model and map Insert operation to use this SP.
I solved it.
1. Created Insert, Update, Delete stored procedures.
2. Imported Table, Insert, Update, Delete stored procedures from DB in EF GUI.
3. Mapped stored procedures in EF GUI.
4. Mapped stored procedure parameters in EF GUI.
5. Manually mapped the XmlType stored procedure parameters in the edmx file, since it did not show up in the parameter dropdown.