public void TestUpdateCollection()
{
using (Model.Context db = new Model.Context("mdbConnectionString"))
{
Author a = new Author();
a.Username = "Jenny";
a.Posts = new List<Post>();
Post p = new Post();
p.Content = "Test post content";
Post pp = new Post();
pp.Content = "Another test content";
a.Posts.Add(p);
a.Posts.Add(pp);
db.InsertOnSubmit<Author>(a); // assume it works, tested on other methods
db.SubmitChanges();
a.Posts.First().Content = "Last content";
db.UpdateOnSubmit<Author>(a, Context.CascadeStyle.All);
db.SubmitChanges();
Post compare = db.Connection.Query<Post>("SELECT * FROM Posts WHERE Id = " + a.Posts.First().Id).FirstOrDefault();
Assert.AreEqual(compare.Content, a.Posts.First().Content);
db.DeleteOnSubmit<Author>(a, Context.CascadeStyle.All);
db.SubmitChanges();
}
}
