WCF控制事務(wù)具體操作代碼解讀
作者:佚名
WCF控制事務(wù)其實是在服務(wù)器端上進行控制的。我們接下來將會通過一段代碼示例來為大家詳細解讀相關(guān)操作方法,方便大家理解。
WCF開發(fā)工具中對于事務(wù)的相關(guān)處理是一個比較重要的操作技術(shù),我們在學習的過程中需要對此加強注意力。把事務(wù)放到客戶端控制,實際上WCF控制事務(wù)還是在服務(wù)器端的,只不過操作權(quán)給了客戶端而已。思路和WebService實現(xiàn)是一樣的,即用WCF的狀態(tài)化記住控制事務(wù)所需的對象,然后給客戶端提供接口來操作這些對象。
閑話少說,WCF控制事務(wù)代碼如下:
服務(wù)器端代碼:
- [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控制事務(wù)的相關(guān)介紹。
【編輯推薦】
責任編輯:曹凱
來源:
qqread.com