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 return sb protected StringBuilder ExecuteStoredProcedure SOLDatabaseAccessRootSqlDataService dataService StringBuilder sb new StringBuilder int rowAffected 0 SOLDataAccessComponent dac null SqlCommand Command null try SOLDatabaseAccessRootSqlDataServiceCommand serviceCommand string storedProcedure dac new SOLDataAccessComponent Command new SqlCommand storedProcedure new SqlConnection bool output this. PopulateParameters serviceCommand ref Command rowAffected int Command if output foreach SqlParameter parameter in if ------ SOL execute success row affected 0 ------- 1 rowAffected finally if null Command 278 CHAPTER 8 SQL AZURE if null dac return sb private bool PopulateParameters SQLDatabaseAccessRootSqlDataServiceCommand serviceCommand ref SqlCommand Command bool output false string direction try foreach SQLParameterRoot parameterRoot in direction .Trim .ToUpper output direction OUT direction INOUT true false if .StartsWith NCHAR int length 0 length @ 0 length .Value else if .StartsWith VARCHAR int length @ 0 length .Value else if .
