Dears at the forum,

I am performing a non-recrusive save on an entity using the Adapter and the UnitOfWork2.

_uow.AddForSave(Entity, New ConcurrencyFilterFactory().CreatePredicate(ConcurrencyPredicateType.Save, Entity), False, False)

Using the SQL Profiler, I see that the SQL generated does take the predicate into consideration (a WHERE clause is inserted). Testing for optimistic locking (comparing the timestamp column of the table), I found out that the Commit of the UoW2 does not throw an ORMConcurrencyException, even if the number of rows affected is = 0. I downloaded the latest Installer, the date associated with the runtime libraries is 16. 3.2005. The same kind of dave using the normal adapter functioned pretty well!

Best regards

Hi there again,

in the following thread http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=2097 the same problem is described in great detail. I am assuming that the latest installer would contain the solution to this problem, but i keep on getting the same problem :-( Do I need to download a special fix?

Weird. With the runtime libs of 16 march, I test this:

[Test]
[ExpectedException(typeof(SD.LLBLGen.Pro.ORMSupportClasses.ORMConcurrencyException))]
public void UnitOfWorkRestrictionFailTest()
{
    using(DataAccessAdapter adapter = new DataAccessAdapter())
    {
        PredicateExpression filter = new PredicateExpression();
        filter.Add(PredicateFactory.CompareValue(CustomerFieldIndex.CompanyName, ComparisonOperator.Equal, "Soldes"));
        CustomerEntity chops = new CustomerEntity("CHOPS");
        Assert.IsTrue(adapter.FetchEntity(chops));

        UnitOfWork2 uow =new UnitOfWork2();

        chops.Country = "Holland";
        uow.AddForSave(chops, filter, false, false);
        uow.Commit(adapter, true);
    }
}

And it succeeds. (which is logical, CHOPS' company isn't 'Soldes')

Could you please check if the filter actually prohibits the save from updating a row?

Dear Otis,

sorry for the inconvinience, the GAC contained the older versions and I had to update them using the latest version from the installation folder. The deinstallation of the last version required a restart and I missed checking the GAC for the right version.

Again sorry for this

Greetings

PS (here in Hamburg the sun has been shining for the last 4 days, hope you have that too at the coast!)

eugene wrote:

Dear Otis,

sorry for the inconvinience, the GAC contained the older versions and I had to update them using the latest version from the installation folder. The deinstallation of the last version required a restart and I missed checking the GAC for the right version.

Again sorry for this

Greetings

Hey no problem

PS (here in Hamburg the sun has been shining for the last 4 days, hope you have that too at the coast!)

Here too! Now it's cloudy and cold again...