Using TransactionScope returns no data or gives exception
Posted: Tue 03 Mar 2009 10:11
I am using dotConnect for Oracle 5.0.22.0. This scenario does not work in either direct or non-direct mode.
Background: Want to do integration tests
Scenario: Create a new record, save changes and verify the result (read it back).
The scenario works as expected when I am not using TransactionScope.
In direct mode I get no record back.
In non-direct mode I get an ORA-01453 error message (SET TRANSACTION must be first statement of transaction)
Background: Want to do integration tests
Scenario: Create a new record, save changes and verify the result (read it back).
The scenario works as expected when I am not using TransactionScope.
In direct mode I get no record back.
In non-direct mode I get an ORA-01453 error message (SET TRANSACTION must be first statement of transaction)
Code: Select all
using (TransactionScope trans = new TransactionScope())
{
using (Entities entities = new Entities())
{
var qry = from e in entities.Table1
select e;
foreach (Table1 record in qry)
{
Console.WriteLine(record.Id);
}
Console.WriteLine("-----------------------");
Table1 newRecord = Table1.CreateTable1("SOMEID");
entities.AddToTable1(newRecord);
entities.SaveChanges();
var qry2 = from e in entities.Table1
select e;
foreach (Table1 record in qry)
{
Console.WriteLine(record.Id);
}
Console.WriteLine("-----------------------");
}
}