WCF控制事務具體操作代碼解讀
作者:佚名
WCF控制事務其實是在服務器端上進行控制的。我們接下來將會通過一段代碼示例來為大家詳細解讀相關操作方法,方便大家理解。
WCF開發工具中對于事務的相關處理是一個比較重要的操作技術,我們在學習的過程中需要對此加強注意力。把事務放到客戶端控制,實際上WCF控制事務還是在服務器端的,只不過操作權給了客戶端而已。思路和WebService實現是一樣的,即用WCF的狀態化記住控制事務所需的對象,然后給客戶端提供接口來操作這些對象。
閑話少說,WCF控制事務代碼如下:
服務器端代碼:
- [ServiceContract(SessionModeSessionMode=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(InstanceContextModeInstanceContextMode=
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', 'goodgoodgoodgoodgoodgoodgoodgoodgoodgoodgoodgood
goodgoodgoodgoodgood')");- serviceProxy.CommitTransaction();
- }
- catch (Exception ex){Console.WriteLine(ex.Message);
- serviceProxy.RollbackTransaction();
- }
- finally{serviceProxy.ReleaseSession();
- serviceProxy.Close();
- }
- Console.WriteLine("Session Transaction End");
- Console.Read();
以上就是對WCF控制事務的相關介紹。
【編輯推薦】
責任編輯:曹凱
來源:
qqread.com