This is a migrated thread and some comments may be shown as answers.

CUD mapping not working

2 Answers 94 Views
Getting Started
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Jason Maronge
Top achievements
Rank 1
Jason Maronge asked on 10 May 2011, 10:10 PM
I am trying to us the Map Procedure functionality for my object and it maps the stored procedures in the Mapping Details Editor.  I have added those procedures to my database but every time I call update it tries to run a prepared statement and failes.  I have modified the update statement inside the procedure so I can do something different with it so I really need it to call the procedure specified.  What could be going wrong?

What I have is a view as an object that returns some other fields with my object but when I save it I don't want those extra fields from another table to be updated so I have taken them out of the update, and insert statement of the generated procedures.  I hope this makes sense.

I have updated and tried the latest internal build 510.

The procedure names are:
sp__ns__clnt_ssstnc_applied_view
sp__pd__clnt_ssstnc_applied_view
sp__dl__clnt_ssstnc_applied_view


Jason

2 Answers, 1 is accepted

Sort by
0
Jason Maronge
Top achievements
Rank 1
answered on 11 May 2011, 03:06 PM
Essentially I am trying to do this:

http://www.telerik.com/community/forums/orm/getting-started/unable-to-use-sp-to-insert-update-delete-from-view.aspx

I have modified the store procedures so they only update the table I am trying to work with.

I have tried to get the stored procedures to work with a regular table and it does not work their either.  OA keeps using the prepared statements for regular tables that are mapped to stored procedures also.

Jason
0
Damyan Bogoev
Telerik team
answered on 13 May 2011, 04:44 PM
Hi Jason Maronge,

It seems that the issue is related to the Mapping Type when it is set to Attributes. You should change it to XML. The following help article shows how to achieve that goal.
Hope that helps.

Regards,
Damyan Bogoev
the Telerik team
Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
Tags
Getting Started
Asked by
Jason Maronge
Top achievements
Rank 1
Answers by
Jason Maronge
Top achievements
Rank 1
Damyan Bogoev
Telerik team
Share this question
or