How to: Convert CRUD Stored Procedures

This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.

The Entity Framework Conversion Wizard supports conversion of stored procedures. In the following sample Entity Framework model, the Insert/Update/DeleteRegion stored procedures are used to customize the CRUD behavior for the Region entity.

These procedures will be converted successfully by the wizard. However they will not be used as CRUD procedures in the converted model. This is because the specific naming convention for CRUD procedures used in the Telerik Data Access Domain Model. That's why in this specific scenario the EF Conversion Wizard will create three additional procedures (sp_oa_ins__region, sp_oa_upd__region, sp_oa_del__region) and will add them in the domain model.

Note that the original InsertRegion, UpdateRegion and DeleteRegion stored procedures will be converted, too. However, in the converted domain model, sp_oa_ins__region, sp_oa_upd__region, sp_oa_del__region will be used as crud procedures for the Region object. At this point the newly added procedures exist in the domain model, however, they does not exist in the database. The last step you need to perform in order to use the converted domain model runtime is to create the corresponding procedures in the database. You can do that manually, or you can use the Update Database from Model wizard.