Transaction object

[RP]

I have a code like this:

==========================================
private void cmdProceed_Click(object sender, EventArgs e)
{
GenerateAll();
}
==========================================

I want to initialize transaction object just before GenerateAll(). The
GenerateAll procedure contains all the SQL statements, but I want to
set the transaction object before GenerateAll.

 

[Nicholas Paldino [.NET/C# MVP]]

RP,

So what's stopping you from doing this:

private void cmdProceed_Click(object sender, EventArgs e)
{
using (TransactionScope scope = new TransactionScope())
{
GenerateAll();

// Commit the transaction.
scope.Complete();
}
}

 

[RP]

But it is giving error:

Error 23 The type or namespace name 'TransactionScope' could not be
found (are you missing a using directive or an assembly reference?)

What reference or initialization need to be done?