If table A to table B has one to many relation, when i create a new entity a as A and a new entity b as B, I can use a.B.Add(b) and adapter.save(a), which saves A and B at the same time. If A and B have one to one relation, I don't see any Add function as mentioned above. Is ther any other function that could acheive the same for tables with one to one realtion?

Thanks.

lgege wrote:

If table A to table B has one to many relation, when i create a new entity a as A and a new entity b as B, I can use a.B.Add(b) and adapter.save(a), which saves A and B at the same time. If A and B have one to one relation, I don't see any Add function as mentioned above. Is ther any other function that could acheive the same for tables with one to one realtion?

Thanks.

Lgege,

Try

 a.B = b;
adapter.Save(a);

Thanks, Brian

Thanks. I will try that.

One more question on this one. If I do that, do I need to specifically set a.ForeignKey=b.Key or does this a.B=b takes care of this.

bclubb wrote:

lgege wrote:

If table A to table B has one to many relation, when i create a new entity a as A and a new entity b as B, I can use a.B.Add(b) and adapter.save(a), which saves A and B at the same time. If A and B have one to one relation, I don't see any Add function as mentioned above. Is ther any other function that could acheive the same for tables with one to one realtion?

Thanks.

Lgege,

Try

 a.B = b;
adapter.Save(a);

Thanks, Brian

That's been taken care of: if b is new, the fk in a is synced after b is saved, otherwise it's synced right after the assignment. After the assignment, you also only have to save a (using a recursive save, default in adapter), and b is saved automatically as well, in the right order (so first b, then a).

Thanks for your help. It worked.