"Transactionoptions.supported" Issue RRS feed

  • Question

  • i have long been searching for a problem where when saving records into a sql server database only last record or a few of all the records were saved despite using transactions and the system generated errors.

    after a tedious search i got to a point where if i set  the <Transactionoptions.Supported> for my serviced component, the records are save correctly. changing this option to Required or RequiresNew again gives the same behavior of the system and records are not properly saved. sometimes saved all and sometimes none.

    i want to use transactionoptions.requiresnew.

    can anybody tell me how to resolve this problem???

    its urgent....please help!

    Wednesday, June 9, 2010 10:42 AM