Why is LINQ to SQL inserting duplicates into my table?
I am rather new to SQL Server and I normally use PK for everything I want to be unique. I didn't know you could put constraints on things. Thanks You Very Much for your help!
– The_Lorax Apr 23 '09 at 0:00.
Your primay key is based off of both the ReviewID and UniqueID columns. So the combination of both columns must be unique. Do your duplicates have a matching ReviewID and UniqueID?
Your answer was also very helpful and it was hard choosing the best answer. Thank You for your help, it is much appreciated. – The_Lorax Apr 24 '09 at 2:10.
I have recently noticed that it has been creating duplicates in my database despite me having primary keys to prevent it. I was thinking that maybe when I made the table I did something wrong? Does anyone know what the problem could be?
I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.
Related Questions
LINQ 2 SQL :Adding one more table to left join in LINQ 2 SQL statement?
Inserting record into sql from a struct via linq?
Inserting data from one mysql table into another mysql table using a form?
Error when inserting into SQL table with php?
Sql server: inserting into a table within a transaction for logging error occurance?
Why is LINQ to SQL entity association creating a new (duplicate) row when inserting a new record?