Connection Won't Enlist In TransactionScope

I'm getting the following stack trace when trying to use TransactionScope with multiple newly created connections. The exact same code works perfectly in MSSQL 2005. Is there something that I'm missing, or (hopefully) is this going to be fixed for release? Thanks much.

System.InvalidOperationException: The connection object can not be enlisted in transaction scope.
at System.Data.SqlServerCe.SqlCeConnection.Enlist(Transaction tx)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at TransactionScopeBugs.DAO.get_Connection() in DAO.cs:line 35
at TransactionScopeBugs.DAO.Insert(String query) in DAO.cs:line 51
at TransactionScopeBugs.Class1.InsertRecord() in Class1.cs:line 38
at TransactionScopeBugs.Class1.TestTxScope() in Class1.cs:line 54

Class1



Code Block
[TestFixture]
public class Class1
{
protected TransactionScope scope;

[SetUp]
public void Initialize()
{
scope = new TransactionScope();
}

[TearDown]
public void TearDown()
{
scope.Dispose();
}

private int GetRowCount(DAO d)
{
using (DbCommand cmd = d.NewCommand("SELECT COUNT(*) FROM TxScope", d.Connection))
{
return (int)cmd.ExecuteScalar();
}
}

private void InsertRecord()
{
DAO d = new DAO();
int num1 = GetRowCount(d);
string id = d.Insert("INSERT INTO TxScope (name) values ('txscope')");
Assert.IsNotNull(id);
Console.WriteLine(id);
int num2 = GetRowCount(d);
Assert.AreEqual(num1 + 1, num2);
}

[Test]
public void TestTxScope()
{
InsertRecord();
}
}





DAO



Code Block
public class DAO
{
private static readonly DbProviderFactory providerFactory;

static DAO()
{
providerFactory = DbProviderFactories.GetFactory("System.Data.SqlServerCe.3.5");
}

public DbConnection Connection
{
get
{
DbConnection conn = providerFactory.CreateConnection();
if (conn.State == ConnectionState.Closed)
{
conn.ConnectionString = "DataSource="txscope.sdf"";
conn.Open();
}
return conn;
}
}

public DbCommand NewCommand(String query, DbConnection conn)
{
DbCommand cmd = providerFactory.CreateCommand();
cmd.CommandText = query;
cmd.Connection = conn;
return cmd;
}

public string Insert(String query)
{
using (DbConnection con = Connection)
{
using (DbCommand cmd = NewCommand(query, con))
{
cmd.ExecuteNonQuery();
cmd.CommandText = "SELECT @@IDENTITY";
object val = cmd.ExecuteScalar();
return val.ToString();
}
}
}
}