甩掉DTC，实现客户端控制事务-WCF的状态(1)

[ServiceContract(SessionMode=SessionMode.Required)]
public interface IMyService
{
[OperationContract(IsTerminating=true)]
void ReleaseSession();
[OperationContract]
void BeginTransaction();
[OperationContract]
void CommitTransaction();
[OperationContract]
void RollbackTransaction();
[OperationContract]
int ExecuteNonQuery(string strCmdText);
}
[ServiceBehavior(InstanceContextMode=InstanceContextMode.PerSession)]
public class MyService : IMyService
{
private string strConnString = "server=namihei2\\KHOS;database=AEGIS_TEST;uid=sa;pwd=
Password01
!";
private SqlConnection mySqlConnection;
private SqlTransaction mySqlTransaction;

public void ReleaseSession()
{
if (mySqlConnection.State == ConnectionState.Open)
{
mySqlConnection.Close();
}
}
public void BeginTransaction()
{
mySqlConnection = new SqlConnection(strConnString);
mySqlConnection.Open();
mySqlTransaction = mySqlConnection.BeginTransaction();
}
public void CommitTransaction()
{
mySqlTransaction.Commit();
}
public void RollbackTransaction()
{
mySqlTransaction.Rollback();
}
public int ExecuteNonQuery(string strCmdText)
{
try
{
SqlCommand objSqlCommand = new SqlCommand(strCmdText);
objSqlCommand.Connection = mySqlConnection;
objSqlCommand.Transaction = mySqlTransaction;
return objSqlCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new FaultException(ex.Message);
}
}
}

static void Main(string[] args)
{
Console.WriteLine("Session Transaction Begin");
SessionTrans.MyServiceClient serviceProxy = new ConsoleTest.SessionTrans.
MyServiceClient();
try
{
serviceProxy.BeginTransaction();
serviceProxy.ExecuteNonQuery("update ATMAccount set Amount = 1000");
serviceProxy.ExecuteNonQuery("insert into ATMLog(AccountNumber,OperationType) 
values ('888', 'good')");
//serviceProxy.ExecuteNonQuery("insert into ATMLog(AccountNumber,OperationType) 
values ('888', 'goodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgood')");
serviceProxy.CommitTransaction();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
serviceProxy.RollbackTransaction();
}
finally
{
serviceProxy.ReleaseSession();
serviceProxy.Close();
}
Console.WriteLine("Session Transaction End");
Console.Read();