Entity Framework error when inserting into table with trigger - The member with identity 'AutoNumber' does not exist in the metadata collection

Question

When I use Entity Framework to insert a row, I get this error:

The member with identity 'AutoNumber' does not exist in the metadata collection.\r\nParameter name: identity

The problem is an insert trigger on the table.

Here's the table structure:

CustomerID | (identity, auto increment)
FirstName  |
LastName   |

Here's the trigger:

CREATE TRIGGER [dbo].[TR_Customer_INSERT] 
ON [dbo].[Customer]
FOR INSERT
AS
    SET NOCOUNT ON

    SELECT @@IDENTITY AS AutoNumber
    RETURN

Is it possible to use Entity Framework without deleting the trigger? Could I define 'AutoNumber' somehow? Why doesn't it just ignore the results of the trigger?

Update: I gave up and deleted the trigger.

Yes, it's an old trigger and old db structure. I'm able to insert a row if I execute `insert into Customer values('jane','doe')` — scw, Sep 25 '13 at 19:03

score 1 · Accepted Answer · edited May 23 '17 at 12:15

You cannot do this:

Select * from COMPONENT_TYPES_IN_SERVICE cts

where cts.id = @ComponentTypeID;

It returns COMPONENT_TYPES_IN_SERVICE record back to your application and EF tries to copy returned values into SERVICE because it thinks that you are passing back some database generated values.

The member with identity 'component_type_name' does not exist in the metadata collection.\r\nParameter name: identity

score 0 · Answer 2 · edited May 23 '17 at 12:23

0

see this reply

Hence, turn off validation in the EF framework:

context.Configuration.ValidateOnSaveEnabled = false

edited May 23 '17 at 12:23

Community

1
1

answered Jul 28 '14 at 09:31

pask23

714
11
20

Entity Framework error when inserting into table with trigger - The member with identity 'AutoNumber' does not exist in the metadata collection

2 Answers2