Linq to Sql Parent Child

Question

ok, so I'm new to C # to do something, I'm from the ruby ​​world.

I have a one-to-many relationship (parent for children for the sake of this question), and for some reason L2S wanted to create a new parent instead of using the one that already was. Here is the code.

Console.WriteLine(parent.Id); // this equals 1
foreach (string names in names)
{
    Child new_child= new Child();
    new_child.Parent = parent;//now parent.Id would equal the next in the sequence.
    new_child.Name= name


    db.CommitLogs.InsertOnSubmit(new_child);
    db.SubmitChanges();
}

but if i just say

new_child.ParentId = parent.Id

which works great.

Can someone explain to me what is going on?

PS. The parent was found from the database using L2S. all keys, etc. configured correctly. Thank you for understanding.

Answer 1

you could do it as Freddy said:

foreach (string names in names)
{
    Child new_child= new Child();
    new_child.Name= name
    parent.Children.Add(child);
    db.SubmitChanges();
}

But it is possible to simply make a 1 DB call outside the foreach loop:

foreach (string names in names)
{
    Child new_child= new Child();
    new_child.Name= name
    parent.Children.Add(child);
}
db.SubmitChanges();

Answer 2

:

// 1:

foreach (string names in names)
{
    Child new_child= new Child();
    new_child.ParentId = parent.Id;//now parent.Id would equal the next in the sequence.
    new_child.Name= name

    db.CommitLogs.InsertOnSubmit(new_child);
    db.SubmitChanges();
}

// 2:

foreach (string names in names)
{
    Child new_child= new Child();
    new_child.Name= name
    parent.Children.Add(child);
    db.SubmitChanges();
}

Answer 3

parent.Children.Add(new_Child);

//

// .

Answer 4

ORM (SqlMetal DBML) ( Children on the Parent Entity).

foriegn ( ParentId), .

, ( , DataContext).

AFAIK (, Child.Parent = Parent) (, Child.ParentID = ID) , () , , .