Why is my Linq to Entities code duplicating rows?

views:

862

answers:

Why is my Linq to Entities code duplicating rows?

+2 A:

You should be able to do something like this:

Dim ParentId As Guid = DirectCast(TreeViewThings.SelectedItem, Thing).Id
NewThing.Parent = (From t In db.Thing _
                  Where t.Id = ParentId _
                  Select t).First

That will build the hierarchical model you are going for.

achinda99 2009-02-13 18:29:25

That was the nudge in the right direction that I needed. Thanks. It generates an extra select query now, but only the one insert.

Zack Peterson 2009-02-13 18:47:53

No problem. If ParentId is a field in your table, you should be able to do:Dim ParentId As Guid = DirectCast(TreeViewThings.SelectedItem, Thing).IdThing.ParentId = ParentIddb.SaveChanges()TreeViewThings.UpdateLayout()No? It would save you the select.

achinda99 2009-02-13 18:51:30

Lost all the formatting I had, but I'm sure you can figure out what I was trying to say. I never understood why in VB, the syntax used a newline to determine end of statement and not another character (like ";" in C#)

achinda99 2009-02-13 18:52:32

'ParentId' is not a member of 'Thing'. I can't just deal in GUIDs.

Zack Peterson 2009-02-13 20:11:16

I was mistaken. This hasn't quite solved the problem.

Zack Peterson 2009-02-16 15:30:13

What is the error? And how does "set" work for Parent?

achinda99 2009-02-16 19:10:42

I've updated the question with additional information.

Zack Peterson 2009-02-16 20:24:16

ansaurus

tags:

views:

answers:

Why is my Linq to Entities code duplicating rows?

related questions