Introducing Windows Azure- P55:The cloud platform is getting more and more attractive to the computing world. Today, service-oriented architecture (SOA) and aspect-oriented programming (AOP) techniques are widely used in enterprise solutions. A question an IT management team or a software development team may ask is, what is the next trend going to be? Cloud computing seems to be the right answer. | CHAPTER 8 SQL AZURE DateTime connectingStart int timeout 0 while timeout 1 DateTime timeNow TimeSpan timespanElapsed new TimeSpan - - - timeout timespanElapsed timeOutSetting private void CloseConn lock connection while null connection endregion region Public Methods public void BeginTrans if CloseConn OpenConn transaction public void CommitTrans if null transaction CloseConn transaction null public void RollBackTrans 268 CHAPTER 8 SQL AZURE if null transaction CloseConn transaction null public SqlDataReader GetDataReader SqlCommand command try OpenConn connection transaction COMMAND TIMEOUT return finally if transaction null RollBackTrans public Object ExecuteNonOuery SqlCommand command OpenConn connection transaction COMMAND TIMEOUT try int rowsAffected return @ReturnValue @ReturnValue .Value rowsAffected finally if transaction null 269 CHAPTER 8 SQL AZURE RollBackTrans public string ExecuteScalar SqlCommand command try OpenConn connection transaction COMMAND TIMEOUT return .ToString finally if transaction null RollBackTrans public DataSet ExecuteDataSet SqlCommand command DataSet oDataSet new DataSet try SqlDataAdapter da .
