CUD Mapping, Insert does not accept SP without parameter

[Pierick Mellerin]

Hello,

I have an entity/table with two fields:

Id (identity, database calculated)
RowVersion (Timestamp)

In CUD Mapping, if I select "Map Procedure" for Create SP (without parameter, by design) and I update "Database from Model...", The following error is displayed:

System.InvalidOperationException

So, is it possible to map a stored procedure for INSERT without parameter like this:

CREATE PROCEDURE [dbo].[sp_oa_ins__myTable]
AS
    INSERT INTO myTable DEFAULT VALUES
    SELECT scope_identity()
GO

Thanks in advance.

Pierrick

[Pierick Mellerin]

[Addendum]
With Entity Framework 4, there is no problem to associate (mapping) a SP like this (INSERT SP without parameter, by example for a table with two fields: Identity field (Id) and Timestamp field (version field)) with an entity... So, is it a bug for OpenAccess and is it a normal behavior (by design) ? Thanks.

[Damyan Bogoev]

Hello Pierick Mellerin,

Firstly I want to apologize for the inconvenience caused.
It seems to be an issue in the sql generation for stored procedures that are used in CUD mapping scenario. We will do our best to fix the cause for this issue.

Regards,
Damyan Bogoev
the Telerik team

[Pierick Mellerin]

Hello,

I have tested the latest version of OpenAccess (v2011.1.510.1) and the issue is always there: it is not possible to generate a CRUD Insert procedure when the table contains only an identity and a timestamp columns, for example.

Is there any roadmap about the fix of this problem ?

Thanks in advance.

Pierrick

[Damyan Bogoev]

Hi Pierick Mellerin,

I am afraid that the problem is not fixed yet. We will do our best to fix the issue for the next Q2 release.
I am sorry for the inconvenience caused.

Regards,
Damyan Bogoev
the Telerik team