Subsonic 3 - What is the difference between these approaches?

Question

This method works fine:

Person p = new Person(3);
p.Name = "Bob";
p.Update();

However if I have an IQueryable foreign key collection the below fails

var foreignItems = Person.Find(x => x.ID == 3)
foreach(Person p in foreignItems)
{
  p.Name = "Bob";
  p.Update(); /*THROWS EXCEPTION */
}

Exception is thrown in Repository Update as it executes a query from BuildUpdateQuery such as - UPDATE PERSON WHERE ID = {0} which is wrong syntax!

Answer 1

This looks like a bug, you should report it to github (the new host for SubSonic source). In the meantime does calling p.Save() may work around the issue.