IBM Support

Error message: 'An item with the same key has already been added.' while Update Model from Database using IBM DB2 .Net Entity Framework provider.

Troubleshooting


Problem

If you have deployed overloaded stored procedures in database e.g. SP1(IN p1 INT, OUT p2 INT) SP1(IN P1 INT, IN p2 INT, OUT p3 INT) After generating Entity Data model when you try to Update Model from Database, you may receive an error "An Item with the same key has already been added".

Cause

This error is due to limitation in Microsoft Entity Framework that it does not support duplicate name for stored procedures.

Here is a link to Microsoft Forums which should contain the article "Update Model from Database : Error Message : An item with the same key has already been added."

Resolving The Problem


1) Please ensure that you do not have overloaded stored procedures deployed in database.
2) Rename overloaded stored procedures in database to unique value and then update Entity Data Model.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - .NET\/.NET ADO","Platform":[{"code":"PF033","label":"Windows"}],"Version":"9.7;10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21635456