transaction batch

[Debasis Bag]

Dear Sir,

I have a project, which divided into three categories. i) Presentation layer, ii) business layer, and iii) DataExecution Layer.

business layer communicate between 1st and 3rd layer. here my problem is I want update some tables through transaction batch. here I am facing logical concept who to update transaction batch in business layer or dataexecution layer.

In this case if you provide any sample project or Source Code. It will be good for me.

Thanking You

Debasis Bag

[Bill Crawley]

This partly depends on how you are updating the DB and your overall design for the business layer. I.E. if everything is being done in the data layer using Stored procs for example, then it makes sense to put the transaction level here. However, if the business layer is storing persistent data in objects, and these objects reflect the data held in store then you probably want to place some locking mechanism's here otherwise should anything fail you could end up with your business layer out of sync with the data layer.