/Katmai_November_CTP/HelloWorld_CLR/Readme_HelloWorld_CLR.htm
HTML | 564 lines | 485 code | 77 blank | 2 comment | 0 complexity | 224de42caec7f3c65972de4cebcf2c48 MD5 | raw file
1<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp"> 2 <head> 3 <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" /> 4 <META NAME="save" CONTENT="history" /> 5 <title>Readme_HelloWorld_CLR</title> 6 7 8 9 <style TYPE="text/css"> 10body 11{ 12background: #FFFFFF; 13color: #000000; 14font-family: Verdana; 15font-size: medium; 16font-style: normal; 17font-weight: normal; 18margin-top: 0; 19margin-bottom: 0; 20margin-left: 0; 21margin-right: 0; 22width: 100%; 23} 24 25div.#mainSection 26{ 27font-size: 70%; 28width: 100%; 29padding-left: 10; 30margin-right: 10; 31} 32 33div.#mainBody 34{ 35font-size: 90%; 36margin-top: 10; 37padding-bottom: 20; 38} 39 40div.#header 41{ 42background-color: #D2D2D2; 43padding-top: 0; 44padding-bottom: 0; 45padding-left: 10; 46padding-right: 0; 47width: 100%; 48} 49 50div.#header table 51{ 52border-bottom-color: #C8CDDE; 53border-bottom-style: solid; 54border-bottom-width: 1; 55width: 100%; 56} 57 58span.#runningHeaderText 59{ 60color: #003399; 61font-size: 90%; 62} 63 64span.#nsrTitle 65{ 66/* color: #003399;*/ 67font-size: 120%; 68font-weight: 600; 69} 70 71div.#header table td 72{ 73color: #000000; 74font-size: 70%; 75margin-top: 0; 76margin-bottom: 0; 77padding-right: 20; 78} 79 80div.#header table tr.#headerTableRow3 td 81{ 82padding-bottom: 2; 83padding-top: 5; 84} 85 86div.#header table.#bottomTable 87{ 88border-top-color: #FFFFFF; 89border-top-style: solid; 90border-top-width: 1; 91text-align: left; 92} 93 94div.#footer 95{ 96font-size: 90%; 97margin-top: 0; 98margin-bottom: 0; 99margin-left: -5; 100margin-right: 0; 101padding-top: 2; 102padding-bottom: 2; 103padding-left: 0; 104padding-right: 0; 105width: 100%; 106} 107 108hr.#footerHR 109{ 110border-bottom-color: #EEEEFF; 111border-bottom-style: solid; 112border-bottom-width: 1; 113border-top-color: C8CDDE; 114border-top-style: solid; 115border-top-width: 1; 116height: 3; 117color: #D2D2D2; 118} 119 120div.section 121{ 122padding-top: 2; 123padding-bottom: 2; 124padding-right: 15; 125width: 100%; 126} 127 128.heading 129{ 130color: #000000; 131font-weight: bold; 132margin-top: 18; 133margin-bottom: 8; 134} 135 136h1.heading 137{ 138color: #000000; 139font-size: 150%; 140} 141 142.subHeading 143{ 144color: #000000; 145font-weight: bold; 146font-size: 150%; 147margin-bottom: 4; 148} 149 150h2.subHeading 151{ 152color: #000000; 153font-weight: bold; 154font-size: 130%; 155} 156h3.subHeading 157{ 158color: #000000; 159font-size: 125%; 160font-weight: bold; 161} 162 163h4.subHeading 164{ 165color: #000000; 166font-size: 110%; 167font-weight: bold; 168} 169 170h4.procedureHeading 171{ 172color: #000080; 173font-size: 110%; 174font-weight: bold; 175} 176 177h5.subHeading 178{ 179color: #000000; 180font-size: 100%; 181font-weight: bold; 182} 183 184img 185{ 186padding-bottom: 10; 187} 188 189img.toggle 190{ 191border: 0; 192margin-right: 5; 193padding-bottom: 10; 194} 195 196img.copyCodeImage 197{ 198border: 0; 199margin: 1; 200margin-right: 3; 201padding-bottom: 10; 202} 203 204img.downloadCodeImage 205{ 206border: 0; 207margin-right: 3; 208padding-bottom: 10; 209} 210 211img.viewCodeImage 212{ 213border: 0; 214margin-right: 3; 215padding-bottom: 10; 216} 217 218img.note 219{ 220border: 0; 221margin-right: 3; 222padding-bottom: 10; 223} 224 225img.#membersOptionsFilterImage 226{ 227border: 0; 228margin-left: 10; 229vertical-align: middle; 230padding-bottom: 10; 231} 232 233img.#toggleAllImage 234{ 235margin-left: 4; 236vertical-align: middle; 237padding-bottom: 10; 238} 239 240div.#mainSection table 241{ 242border: 0; 243font-size: 100%; 244width: 100%; 245margin-top: 5px; 246margin-bottom: 15px; 247} 248 249div.#mainSection table tr 250{ 251vertical-align: top; 252} 253 254div.#mainSection table th 255{ 256text-align: left; 257background: #D8D8D8; 258border-bottom-color: #D8D8D8; 259border-bottom-style: solid; 260border-bottom-width: 1; 261color: #000000; 262padding-left: 5; 263padding-right: 5; 264} 265 266div.#mainSection table td 267{ 268background: #F2F2F2; 269border-top-color: #D8D8D8; 270border-top-style: solid; 271border-top-width: 1; 272padding-left: 5; 273padding-right: 5; 274} 275 276div.#mainSection table td.imageCell 277{ 278white-space: nowrap; 279} 280 281div.code 282{ 283width: 98%; 284} 285 286div.code table 287{ 288border: 0; 289font-size: 95%; 290margin-bottom: 5; 291width: 100% 292} 293 294div.code table th 295{ 296text-align: left; 297background: #D8D8D8; 298border-bottom-color: #D8D8D8; 299border-bottom-style: solid; 300border-bottom-width: 1; 301color: #000000; 302font-weight: bold; 303padding-left: 5; 304padding-right: 5; 305} 306 307div.code table td 308{ 309background: #CCCCCC; 310border-top-color: #D8D8D8; 311border-top-style: solid; 312border-top-width: 1; 313padding-left: 5; 314padding-right: 5; 315padding-top: 5; 316} 317 318div.alert 319{ 320margin-left: 10; 321width: 98%; 322} 323 324div.alert table 325{ 326border: 1; 327font-size: 100%; 328width: 100%; 329border: solid 1 #DEDFEF; 330} 331 332div.alert table th 333{ 334text-align: left; 335background: #D8D8D8; 336border-bottom-width: 0; 337color: #000000; 338padding-left: 5; 339padding-right: 5; 340border: solid 1 #DEDFEF; 341} 342 343div.alert table td 344{ 345background: #FFFFFF; 346border-top-color: #D8D8D8; 347border-top-style: solid; 348border-top-width: 1; 349padding-left: 5; 350padding-right: 5; 351border: solid 1 #DEDFEF; 352} 353 354span.copyCode 355{ 356color: #0000ff; 357font-size: 90%; 358font-weight: normal; 359cursor: hand; 360float: right; 361display: inline; 362text-align: right; 363} 364 365.downloadCode 366{ 367color: #0000ff; 368font-size: 90%; 369font-weight: normal; 370cursor: hand; 371} 372 373.viewCode 374{ 375color: #0000ff; 376font-size: 90%; 377font-weight: normal; 378cursor: hand; 379} 380 381div.code pre 382{ 383font-family: Monospace, Courier New, Courier; 384font-size: 105%; 385color: #000000; 386} 387 388code 389{ 390font-family: Monospace, Courier New, Courier; 391font-size: 105%; 392color: #000000; 393} 394 395dl 396{ 397margin-top: 0; 398padding-left: 1; 399} 400 401dd 402{ 403margin-bottom: 0; 404margin-left: 0; 405padding-left: 20; 406} 407 408dd p 409{ 410margin-top: 5; 411} 412 413ul 414{ 415margin-left: 17; 416list-style-type: disc; 417} 418 419ul ul 420{ 421margin-bottom: 4; 422margin-left: 17; 423margin-top: 3; 424list-style-type: disc; 425} 426 427ol 428{ 429margin-left: 24; 430list-style-type: decimal; 431} 432 433ol ol 434{ 435margin-left: 24; 436margin-top: 3; 437list-style-type: lower-alpha; 438} 439 440li 441{ 442margin-top: 0; 443margin-bottom: 0; 444padding-bottom: 0; 445padding-top: 0; 446margin-left: 5; 447} 448 449p 450{ 451margin-bottom: 15; 452} 453 454.tip 455{ 456color: #0000FF; 457font-style: italic; 458cursor:hand; 459text-decoration:underline; 460} 461 462.math 463{ 464font-family: Times New Roman; 465font-size: 125% 466} 467.sourceCodeList 468{ 469font-family: Verdana; 470font-size: 90%; 471} 472 473pre.viewCode 474{ 475width: 100%; 476overflow: auto; 477} 478 479li:hover table, li.over table 480{ 481background-color: #C0C0C0; 482} 483 484li:hover ul, li.over ul 485{ 486background-color: #d2d2d2; 487border: 1px solid #000; 488display: block; 489} 490 </style> 491 </head> 492 <body> 493 <!--Topic built:10/29/2007 02:41:57--> 494 495 496 497 498 499 500 501 502 503 504 <div id="header"> 505 <table width="100%" id="topTable"><tr> 506 <td align="left"> 507 <span id="nsrTitle">Readme_HelloWorld_CLR</span> 508 </td> 509 <td align="right"> 510 <span id="headfb" class="feedbackhead"> 511 </span> 512 </td> 513 </tr></table> 514 515 516 517 </div> 518 <div id="mainSection"> 519 <div id="mainBody"><p> 10/29/2007 2:41:57 AM</p> 520 521 <font color="DarkGray">[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.] </font><p /> 522 <span id="changeHistory"> 523 </span> 524 <p>This sample shows a simple, stateless application that uses the ServiceBrokerInterface sample.</p> 525 <p> 526 Samples are provided for educational purposes only. They are not intended to be used in a production environment and have not been tested in a production environment. Microsoft does not provide technical support for these samples. Sample applications and assemblies should not be connected to or used with your production SQL Server database or your report server without the permission of the system administrator. 527 </p> 528 <h4 class="procedureHeading">Building and Installing the sample</h4><div id="procedureSectionEJBHA" class="section"><ol><li> 529 <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 530 <p xmlns="">In Visual Studio 2005, open <code>HelloWorldCS.sln</code> or <code>HelloWorldVB.sln</code>.</p> 531 </content> 532 </li><li> 533 <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 534 <p xmlns="">Build the solution by pressing <b>F6</b>, or by selecting <b>Build Solution</b> from the <b>Build</b> menu.</p> 535 </content> 536 </li><li> 537 <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 538 <p xmlns="">Run <code>Install.cmd</code>, located in the <code>Scripts</code> folder of the <code>HelloWorld_CLR</code> directory. This file sets up the environment, and then runs the <code>Install.sql</code> install script. If you built the Visual Basic version of the project, you might have to change the "cs" in the path for the assembly to "vb" in the <code>Install.sql</code> script.</p> 539 </content> 540 </li></ol></div><h4 class="procedureHeading">Running the sample</h4><div id="procedureSectionEHBHA" class="section"><ol><li> 541 <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 542 <p xmlns="">Run the <code>HelloWorldClient.exe</code> console application from the sample directory. To exit the client, press <b>Enter</b> after the client shows the response.</p> 543 </content> 544 </li></ol></div><h1 class="heading">Requirements</h1><div id="requirementsSection" class="section"> 545 <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 546 <p xmlns="">This sample requires Visual Studio 2005. Because the sample uses features of the common language runtime (CLR) that were not available in earlier versions, versions of Visual Studio earlier than 2005 cannot build the sample.</p> 547 </content> 548 </div><h1 class="heading">Demonstrates</h1><div id="demonstratesSection" class="section"> 549 <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5"> 550 <p xmlns="">This sample demonstrates use of the sample object-oriented programming interface provided in the Service Broker Interface sample. All Service Broker functionality for the sample uses the Service Broker Interface.</p> 551 <p xmlns="">There are two main parts of the sample: a client program that runs outside of SQL Server, and a CLR stored procedure that implements the service.</p> 552 <p xmlns="">The external program begins a conversation from the service <b>HelloWorldClient</b> to the service <b>HelloWorldService</b>, and then sends a message on that conversation. This application sends a <b>Request</b> message to the service <b>HelloWorldService</b>. The activated stored procedure receives and responds to the message. The client receives a response, shows the response on the console, and then ends the dialog.</p> 553 <p xmlns="">The CLR stored procedure implements the <b>HelloWorldService</b>. Service Broker activates this procedure. The procedure reads a message from the queue. For a <b>Request</b> message, the procedure responds with a Response message. For a Service Broker end dialog message, the procedure ends the conversation.</p> 554 </content> 555 </div><!--[if gte IE 5]> 556 <tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/> 557 <![endif]--></div> 558 <div id="footer"> 559 560 © 2007 Microsoft Corporation. All rights reserved. 561 </div> 562 </div> 563 </body> 564</html>