public static void TransactionPromotion()
{
var tx = new CommittableTransaction();
Utility.DisplayTransactionInfo("TX Created", tx.TransactionInformation);
try
{
var db = new StudentData();
var s1 = new Student()
{
FirstName = "Z1", LastName = "ff", Company = "fff"
};
db.AddStudent(s1, tx);
var s2 = new Student()
{
FirstName = "first0", LastName = "last", Company = "COM"
};
db.AddStudent(s2, tx);
Utility.DisplayTransactionInfo("2nd connection enlished", tx.TransactionInformation);
tx.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.WriteLine();
tx.Rollback();
}
}
public static async Task CommitTableTransactionAsync()
{
var tx = new CommittableTransaction();
Utility.DisplayTransactionInfo("Tx Created", tx.TransactionInformation);
try
{
var s1 = new Student()
{
FirstName = "Wei", LastName = "EN", Company = "WN"
};
var db = new StudentData();
await db.AddStudentAsync(s1, tx);
//if()
tx.Commit();
}
catch (Exception ex)
{
Console.WriteLine(ex);
tx.Rollback();
}
Utility.DisplayTransactionInfo("Tx Completed:", tx.TransactionInformation);
}
static async void AddStudent()
{
Student student = new Student()
{
FirstName = "ff",
LastName = "ss",
Company = "ms"
};
StudentData studentData = new StudentData();
Task <int> t = studentData.AddStudentAsync(student);
int num = await t;
await CommittableSamples.CommitTableTransactionAsync();
CommittableSamples.TransactionPromotion();
Console.WriteLine(num);
}