Now we will discuss transaction processing as it relates to the c-treeACE SQL ADO.NET Data Provider using C#.
Transaction processing provides a safe method by which multiple database operations spread across separate tables/files are guaranteed to be atomic. By atomic, we mean that, within a transaction, either all of the operations succeed or none of the operations succeed. This "either all or none" atomicity insures that the integrity of the data in related tables/files is secure.
Like all other examples in the c-tree tutorial series, this tutorial simplifies the creation and use of a database into four simple steps: Initialize(), Define(), Manage(), and You’re Done() !
Tutorial #4: Transaction Processing
Here we demonstrate transaction control.
Note our simple mainline:
// declare connection, command and reader objects
static CtreeSqlConnection conn;
static CtreeSqlCommand cmd;
static CtreeSqlDataReader rdr;
// The main() function implements the concept of "init, define, manage
// and you're done..."
static void Main()
Console.Write("\nPress <ENTER> key to exit . . .");
We suggest opening the source code with your own editor.
Continue now to review these four steps.