public void ConcurrencyOnUpdate()
{
OracleTestCollection collection = new OracleTestCollection();
int testId = 0;
switch (collection.es.Connection.ProviderSignature.DataProviderName)
{
case "EntitySpaces.OracleClientProvider":
try
{
using (esTransactionScope scope = new esTransactionScope())
{
// Setup
OracleTest entity = new OracleTest();
entity.Save();
testId = (int)entity.Id.Value;
// Test
entity = new OracleTest();
entity.LoadByPrimaryKey(testId);
entity.str().DateType = "2007-01-01";
OracleTest entity2 = new OracleTest();
entity2.LoadByPrimaryKey(testId);
entity2.str().DateType = "1999-12-31";
entity.Save();
entity2.Save();
Assert.Fail("Concurrency Exception not thrown.");
}
}
catch (EntitySpaces.Interfaces.esConcurrencyException cex)
{
Assert.AreEqual("ORA-2", cex.Message.ToString().Substring(0, 5));
}
finally
{
// Cleanup
OracleTest entity = new OracleTest();
if (entity.LoadByPrimaryKey(testId))
{
entity.MarkAsDeleted();
entity.Save();
}
}
break;
default:
Assert.Ignore("Oracle only.");
break;
}
}
