Re: Commit with validation errors in detail table

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed May 07 2008 - 03:12:03 EDT

  • Next message: Fixe106: "Re: Commit with validation errors in detail table"

    Hi Julien,

    Yes, DataContext commit is all or nothing. One possible way to go
    about it is to catch the ValidationException, iterate through the list
    of failures collecting source objects of all failures. Then do
    DataContext.invalidateObjects(failed) and retry the commit.

    Andrus

    On May 6, 2008, at 6:35 PM, Julien Trolliet wrote:

    > Hi
    > I have a 2 tables with a One-to-many relations. (Master-Details)
    > My code insert one row in the Master table and many rows in the
    > Details table
    > at the end I do a dataContext.commitChanges();
    > But in some rows in the Details table I have some Validation failures
    > Finally I have no row commited in the DB
    > I would like a sort of commit with ignore errors. The good rows in
    > Details will be committed in DB and the bad ones will be ignored.
    > How can I implement that ?
    > Does I need to play with Nested DataContext ?
    > Thank you for your clues.
    > Best regards.
    > Julien
    >
    >

    This archive was generated by hypermail 2.0.0 : Wed May 07 2008 - 03:12:47 EDT