You have an existing ContosoEntities context object named context. Calling the SaveChanges() method on the context object generates an exception that has the following inner exception:

System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Colors' with unique index 'IX_Colors'. You need to ensure that a call to SaveChanges() on the context object does not generate this exception. What should you do?

Question

You have an existing ContosoEntities context object named context. Calling the SaveChanges() method on the context object generates an exception that has the following inner exception:

System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.Colors' with unique index 'IX_Colors'. You need to ensure that a call to SaveChanges() on the context object does not generate this exception. What should you do?

Accepted Answer

A. Examine the code to see how Color objects are allocated.

Answer

B. Add a try/catch statement around every call to the SaveChanges() method.

Answer

C. Remove the unique constraint on the Name column in the Colors table.

Answer

D. Override the SaveChanges() method on the ContosoEntities class,

You have an existing ContosoEntities context object named context. Calling the SaveChanges() method on the context object generates an exception that has the following inner exception…

Question

Options

How the community answered

Community Discussion