How I Solve This Error

Question

4.00/5 (1 vote)

See more:

SQL-Server-2008R2

Hi everybody i'm using linq to insert data into two tables have relation one to many
when insert second time this message appear ??

SQL

Violation of PRIMARY KEY constraint 'PK__customer__26A1118D08EA5793'. Cannot insert duplicate key in object 'dbo.customeraddress'.
The statement has been terminated.

my code :

C#

DbDataContext db = new DbDataContext();

            customer cust = new customer();
            
            cust.firstname = textBox1.Text;
            cust.Lastname = textBox2.Text;
        
            db.customers.InsertOnSubmit(cust);
            db.SubmitChanges();

            customeraddress custaddress = new customeraddress();
           
                custaddress.states = textBox3.Text;
                custaddress.address1 = textBox4.Text;

                cust.customeraddresses.Add(custaddress);
            db.SubmitChanges();

Posted 12-Sep-15 11:09am

mhassan083

Updated 12-Sep-15 11:22am

Maciej Los

v2

Add a Solution

Comments

jgakenhe 12-Sep-15 19:42pm

You probably have a unique index on one of the columns in that table. Depending on how your database is set up, you should probably drop it.

sreeyush sudhakaran 13-Sep-15 0:20am

1)Unique Key you are trying to insert may exists in the table already or
2)Unique Key may be foreign key from another table which may not yet present in the parent table.

If you are trying to insert foreign keys give importance in insertion sequence
Parent table should be filled before child tables referencing that.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-09-12T18:47:00

The error message is quite clear, you're trying to insert a row that contains the exact same data that already exists in another row in your table in the column(s) you have defined as primary key.

The purpose of the primary key is to prevent duplicates, hence the error message.

In order to see the primary key, open Sql Server Management Studio, navigate to your database and table, right click the table and select Design. There you should see a key icon in front of the column(s) that is primary key.

Another option is to run a query to get the primary key info. For that you can try the following:

SQL

SELECT a.TABLE_CATALOG,
       a.TABLE_NAME,
       a.COLUMN_NAME,
       a.ORDINAL_POSITION
FROM  INFORMATION_SCHEMA.KEY_COLUMN_USAGE a
WHERE a.CONSTRAINT_NAME = 'PK__customer__26A1118D08EA5793'
ORDER BY a.ORDINAL_POSITION