UOW and Oracle
Joined: 26-Mar-2010
It seems you are not using an explicit (extrenal) Transaction object to govern this.
When you call Commit() on a UoW it commits all actions. Then when you add another actions and call Commit() again, it commits all the newly added actions.
Everytime it uses a separate implicit (internal) Transaction, so each Commit() will have nothing to do with the other. unless. 
Unless you use a Transaction object, and pass false to the UoW.Commit() overload which accepts an AutoCommit parameter, in order not to call commit of the external transaction object.
And then after calling UoW.Commit() several times, you call Commit() on the Transaction object to Commit the external transaction.
Joined: 26-Mar-2010
Walaa wrote:
It seems you are not using an explicit (extrenal) Transaction object to govern this.
When you call Commit() on a UoW it commits all actions. Then when you add another actions and call Commit() again, it commits all the newly added actions. Everytime it uses a separate implicit (internal) Transaction, so each Commit() will have nothing to do with the other. unless.
Unless you use a Transaction object, and pass false to the UoW.Commit() overload which accepts an AutoCommit parameter, in order not to call commit of the external transaction object.
And then after calling UoW.Commit() several times, you call Commit() on the Transaction object to Commit the external transaction.
Dear Walaa I think I am lost some where ! Though the forum rules says not post entire code, in my case I felt it would be prudent to attach full code to clearly understand where I am going wrong. I am really stuck with UOW for long
Or let us look at this small code. If financial year id is 0, it commits event entity but it should not because billcounter is not saved becoz of foreign key violation
private void Savedata() { var adapterevent = new DataAccessAdapter(); try {
int FinancialYearID = MonthlyBill.returnFinancialYearReceipt(string.Format("{0:dd/MMM/yyyy}",
dateeventdate.Value.Date));
string message;
var eventuow = new UnitOfWork2();
var evententity = new EventEntity();
evententity.Description = ChangeCase.ToTitleCase(tbxdescription.Text.Trim());
evententity.Eventdate = dateeventdate.Value;
evententity.Createddate = ServerDateTime.getcurrentserverdatewithtime();
evententity.CreateduserId = StandardMessage.loginuserid;
eventuow.AddForSave(evententity);
var billcountermember = new BillcounterEntity();
evententity.Billcounters.Add(billcountermember);
billcountermember.Billnumber = 0;
billcountermember.FinancialfunctionalyearId = FinancialYearID;
billcountermember.Createddate = ServerDateTime.getcurrentserverdatewithtime();
billcountermember.CreateduserId = StandardMessage.loginuserid;
billcountermember.Ismember = GlobalVariable.optionYes;
eventuow.AddForSave(billcountermember);
var billcounterguest = new BillcounterEntity();
evententity.Billcounters.Add(billcounterguest);
billcounterguest.Billnumber = 0;
billcounterguest.FinancialfunctionalyearId = FinancialYearID;
billcounterguest.Createddate = ServerDateTime.getcurrentserverdatewithtime();
billcounterguest.CreateduserId = StandardMessage.loginuserid;
billcounterguest.Ismember = GlobalVariable.optionNo;
eventuow.AddForSave(billcounterguest);
eventuow.Commit(adapterevent,true);
{
message = StandardMessage.datasavesuccess;
DoRefresh();
}
MessageBox.Show(message);
}
catch (Exception ex)
{
GlobalErrorHandler.LogMessage(ex.Message + ex.StackTrace);
MessageBox.Show(StandardMessage.datasavefailure);
}
finally
{
adapterevent.CloseConnection();
adapterevent.Dispose();
}
}
Joined: 26-Mar-2010
Joined: 26-Mar-2010
Joined: 26-Mar-2010
Joined: 26-Mar-2010
Joined: 26-Mar-2010
Does the same happens when using the Transaction object alone without using the UoW?
Yes Walaa
Could you please post a very simple and minimal repro solution based on Northwind?
Joined: 26-Mar-2010
Walaa wrote:
Does the same happens when using the Transaction object alone without using the UoW?
Yes Walaa
Can I just give you the two tables structure and sample data ?
Joined: 26-Mar-2010
shekar wrote:
Walaa wrote:
Does the same happens when using the Transaction object alone without using the UoW?
Yes Walaa
Can I just give you the two tables structure and sample data ?
Please let me know if the attached file is sufficient
Joined: 26-Mar-2010
[quotenick="shekar"]
shekar wrote:
Walaa wrote:
Does the same happens when using the Transaction object alone without using the UoW?
Yes Walaa
Can I just give you the two tables structure and sample data ?
Attached
| Filename | File size | Added on | Approval |
|---|---|---|---|
| Test Tables.txt | 8,937 | 12-Apr-2011 11:44.11 | Approved |
Joined: 08-Oct-2008
Thanks - but we could really do with the code to make the error happen as well. Please don't think that we are trying to make things awkward for you. The more work you can do up front for us the easier things are! Don't forget you know your code a lot better than we do, it's much easier for you do make it fail than for us
Thanks
Matt
Joined: 26-Mar-2010
MTrinder wrote:
Thanks - but we could really do with the code to make the error happen as well. Please don't think that we are trying to make things awkward for you. The more work you can do up front for us the easier things are! Don't forget you know your code a lot better than we do, it's much easier for you do make it fail than for us
Thanks
Matt
Dear MTrinder, Thanks for response and I shall wait for the solution. For sure, I have learnt LLBLGen to greater extent and have been successful in many ways. It is only this UOW which causing problem for me since long and I have tried all possible combinations but for no luck. If you see my first post on this, I also tried passing larger value than the column length and it rolls back perfectly OK. But when FK's are violated it does not roll back so I am confident that there is nothing wrong in the code
Joined: 26-Mar-2010
Joined: 26-Mar-2010
Joined: 26-Mar-2010