The title says it all. I have a m:n relationship table UserRoles with the identity Id and the two foreign keys UserUserId and RoleRoleId. Then when I try to persist such a UserRolesEntity instance, I get the error

Cannot insert explicit value for identity column in table 'UserRoles' when IDENTITY_INSERT is set to OFF.

because the adapter tries to insert a zero there as Id instead of not filling the value:

INSERT INTO [eTrash].[dbo].[UserRoles] ([Id], [UserUserId], [RoleRoleId]) VALUES (0,4,3)

With all other entities, inserts work without problems. What could I possibly be doing wrong?

Please check the field mapping in the LBLGen Pro Designer. It should have Scope_Identity() under the Sequence column.

I resolved this problem. Actually the Id field was set to SCOPE_IDENTITY already and committed in the database, but I had forgotten to re-generate the adapter code. Thanks for your help!