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

by

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
    }
    else throw;
}

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.

More Related Contents:

  1. summing values of a column based on id [closed]
  2. MSSQL Error ‘The underlying provider failed on Open’
  3. Conversion of a datetime2 data type to a datetime data type results out-of-range value
  4. Getting data from stored procedure with Entity Framework
  5. Entity framework very slow to load for first time after every compilation
  6. Writing Recursive CTE using Entity Framework Fluent syntax or Inline syntax
  7. How can I lock a table on read, using Entity Framework?
  8. Mapping composite keys using EF code first
  9. EF 6 – How to correctly perform parallel queries
  10. Entity-framework code is slow when using Include() many times
  11. ‘datetime2’ error when using entity framework in VS 2010 .net 4.0
  12. Delete a single record from Entity Framework?
  13. Optimistic concurrency: IsConcurrencyToken and RowVersion
  14. Entity Framework 6 transaction rollback
  15. The LINQ expression could not be translated and will be evaluated locally
  16. Dynamic query with OR conditions in Entity Framework
  17. Entity Framework | Sequence contains more than one matching element
  18. Keyword Not Supported: Metadata
  19. Why is EF generating SQL queries with unnecessary null-checks?
  20. How to Specify Primary Key Name in EF-Code-First
  21. Should the order of LINQ query clauses affect Entity Framework performance?
  22. Watch for a table new records in sql database
  23. EntityType has no key defined error
  24. LEFT JOIN in LINQ to entities?
  25. Entity Framework Filter “Expression”
  26. Self-referencing many-to-many recursive relationship code first Entity Framework
  27. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  28. Is it possible to use SqlGeography with Linq to Sql?
  29. Use both AddDbContextFactory() and AddDbContext() extension methods in the same project
  30. Cyrillic encoding in C#

Leave a Comment