Đang chuẩn bị liên kết để tải về tài liệu:
Introducing Windows Azure- P57

Introducing Windows Azure- P57: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 dac.Dispose return sb protected StringBuilder ExecuteStoredProcedure SOLDatabaseAccessRootSqlDataService dataService StringBuilder sb new StringBuilder int rowAffected 0 SOLDataAccessComponent dac null SqlCommand Command null try SOLDatabaseAccessRootSqlDataServiceCommand serviceCommand dataService.Command string storedProcedure serviceCommand.Text dac new SOLDataAccessComponent this.ConnectionString Command new SqlCommand storedProcedure new SqlConnection Command.CommandType CommandType.StoredProcedure bool output this. PopulateParameters serviceCommand ref Command dac.BeginTrans rowAffected int dac.ExecuteNonOuery Command dac.CommitTrans if output foreach SqlParameter parameter in Command.Parameters if parameter.Direction ParameterDirection.Output sb.Append parameter.Value.ToString sb.Append Environment.NewLine sb.Append string.Format ------ SOL execute success row affected 0 ------- 1 rowAffected Environment.NewLine sb.Append Environment.NewLine finally if null Command 278 CHAPTER 8 SQL AZURE Command.Dispose if null dac dac.Dispose return sb private bool PopulateParameters SQLDatabaseAccessRootSqlDataServiceCommand serviceCommand ref SqlCommand Command bool output false string direction string.Empty try Command.Parameters.Clear foreach SQLParameterRoot parameterRoot in serviceCommand.SQLParameterRoot direction parameterRoot.Parameter.Direction.ToString .Trim .ToUpper output direction OUT direction INOUT true false if parameterRoot.Parameter.Type.ToUpper .StartsWith NCHAR int length 0 length Convert.ToInt32 parameterRoot.Parameter.Size Command.Parameters.Add string.Format @ 0 parameterRoot.Parameter.Name SqlDbType.NChar length .Value parameterRoot.Parameter.Value else if parameterRoot.Parameter.Type.ToUpper .StartsWith VARCHAR int length Convert.ToInt32 parameterRoot.Parameter.Size Command.Parameters.Add string.Format @ 0 parameterRoot.Parameter.Name SqlDbType.VarChar length .Value parameterRoot.Parameter.Value else if .