Roshan Roshan - 1 year ago 87
C# Question

How to Identify the primary key duplication from a SQL Server 2008 error code?

I want to know how we identify the primary key duplication error from SQL Server error code in C#.

As a example, I have a C# form to enter data into a SQL Server database, when an error occurs while data entry, how can I identify the reason for the error from the exception?

Answer Source

If you catch SqlException then see its number, the number 2627 would mean violation of unique constraint (including primary key).

try
{
  //insertion code
}
catch(SqlException ex)
{
  if(ex.Number == 2627)
    {
     //Violation of primary key. Handle Exception
    }
}

MSSQL_ENG002627

This is a general error that can be raised regardless of whether a database is replicated. In replicated databases, the error is typically raised because primary keys have not been managed appropriately across the topology.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download