StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
16673660
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-05-21T15:23:08.290
FavoriteCount
0
LastActivityDate
2013-05-21T15:50:23.973
LastEditDate
2013-05-21T15:50:23.973
LastEditorUserId
1945631
OwnerUserId
1945631
ParentId
16672309
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
If two or more <code>student in _xStudents.Descendants("Student")</code> reference the same parent (by id), you then create two or more <code>ParentDTO</code>s with the same id, so you are then trying to insert the same Primary Key twice within your <code>Importer</code> class. If you simply pre-process your <code>_xParents</code>, to transform them into a new list of ParentDTO, which is unique by <code>ParentId</code> you can then use that in your <code>var query</code> to get a reference to the single <code>ParentDTO</code> instance that refers to the given ParentId PK. This code sample doesn't change your code much so that you can easily relate it to your original. Note, however, that you can probably optimise this, and you will also have the same problem with your <code>SubjectDTO</code> list as well if you are using <code>SubjectDTO.Name</code> to be unique (as you should be, I guess). <pre><code>var parents = (from parent in _xParents.Descendants("Parent").DefaultIfEmpty() group parent by (String)parent.Element("ParentId") into pg select new ParentDTO { ParentId = (long)pg.FirstOrDefault().Element("ParentId"), Name = (String)pg.FirstOrDefault().Element("Name") // you might want to not use ToList here and let parents be an IEnumerable instead }).ToList(); var query = from student in _xStudents.Descendants("Student") select new StudentDTO { StudentId = (long)student.Element("StudentId"), Name = (String)student.Element("Name"), Subjects = ( from subject in _xSubjects.Descendants("Subject").DefaultIfEmpty() where (String)student.Element("StudentId") == (String)subject.Element("StudentId") select new SubjectDTO { Name = (String)subject.Element("Name") } ).ToList(), Parents = ( from parent in parents // Calling ToString each time is not fantastic where (String)student.Element("Parent1") == parent.ParentId.ToString() || (String)student.Element("Parent2") == parent.ParentId.ToString() || (String)student.Element("Parent3") == parent.ParentId.ToString() select parent ).ToList() }; </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POViolation of PRIMARY KEY constraint: Cannot insert duplicate key in object
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAndy Brown
UserOwnerUserId
1. USAndy Brown
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POViolation of PRIMARY KEY constraint: Cannot insert duplicate key in object
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
CommentsPostId
1. COThanks, this solution helped me continue.
 singulars
 PostPostId
 PO
 UserUserId
 USNaNerd

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.