/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. 

  2.   <head>

    3. 

  3.     <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />

    4. 

  4.     <META NAME="save" CONTENT="history" />

    5. 

  5.     <title>Readme_HelloWorld_CLR</title>

    6. 

  6.     

    7. 

  7.     

    8. 

  8.     

    9. 

  9.     <style TYPE="text/css">

    10. 

  10. body

    11. 

  11. {

    12. 

  12. background: #FFFFFF;

    13. 

  13. color: #000000;

    14. 

  14. font-family:    Verdana;

    15. 

  15. font-size: medium;

    16. 

  16. font-style: normal;

    17. 

  17. font-weight: normal;

    18. 

  18. margin-top: 0;

    19. 

  19. margin-bottom:  0;

    20. 

  20. margin-left:    0;

    21. 

  21. margin-right:   0;

    22. 

  22. width:  100%;

    23. 

  23. }

    24. 

  24. 

    25. 

  25. div.#mainSection

    26. 

  26. {

    27. 

  27. font-size: 70%;

    28. 

  28. width: 100%;

    29. 

  29. padding-left:    10;

    30. 

  30. margin-right: 10;

    31. 

  31. }

    32. 

  32. 

    33. 

  33. div.#mainBody

    34. 

  34. {

    35. 

  35. font-size: 90%;

    36. 

  36. margin-top: 10;

    37. 

  37. padding-bottom: 20;

    38. 

  38. }

    39. 

  39. 

    40. 

  40. div.#header

    41. 

  41. {

    42. 

  42. background-color: #D2D2D2;

    43. 

  43. padding-top:    0;

    44. 

  44. padding-bottom: 0;

    45. 

  45. padding-left:   10;

    46. 

  46. padding-right:  0;

    47. 

  47. width:          100%;

    48. 

  48. }

    49. 

  49. 

    50. 

  50. div.#header table

    51. 

  51. {

    52. 

  52. border-bottom-color: #C8CDDE;

    53. 

  53. border-bottom-style: solid;

    54. 

  54. border-bottom-width: 1;

    55. 

  55. width:  100%;

    56. 

  56. }

    57. 

  57. 

    58. 

  58. span.#runningHeaderText

    59. 

  59. {

    60. 

  60. color: #003399;

    61. 

  61. font-size: 90%;

    62. 

  62. }

    63. 

  63. 

    64. 

  64. span.#nsrTitle

    65. 

  65. {

    66. 

  66. /*    color: #003399;*/

    67. 

  67. font-size: 120%;

    68. 

  68. font-weight: 600;

    69. 

  69. }

    70. 

  70. 

    71. 

  71. div.#header table td

    72. 

  72. {

    73. 

  73. color: #000000;

    74. 

  74. font-size: 70%;

    75. 

  75. margin-top: 0;

    76. 

  76. margin-bottom:  0;

    77. 

  77. padding-right: 20;

    78. 

  78. }

    79. 

  79. 

    80. 

  80. div.#header table tr.#headerTableRow3 td

    81. 

  81. {

    82. 

  82. padding-bottom: 2;

    83. 

  83. padding-top: 5;

    84. 

  84. }

    85. 

  85. 

    86. 

  86. div.#header table.#bottomTable

    87. 

  87. {

    88. 

  88. border-top-color: #FFFFFF;

    89. 

  89. border-top-style: solid;

    90. 

  90. border-top-width: 1;

    91. 

  91. text-align: left;

    92. 

  92. }

    93. 

  93. 

    94. 

  94. div.#footer

    95. 

  95. {

    96. 

  96. font-size: 90%;

    97. 

  97. margin-top: 0;

    98. 

  98. margin-bottom:  0;

    99. 

  99. margin-left:    -5;

    100. 

  100. margin-right:   0;

    101. 

  101. padding-top:    2;

    102. 

  102. padding-bottom: 2;

    103. 

  103. padding-left:   0;

    104. 

  104. padding-right:  0;

    105. 

  105. width:  100%;

    106. 

  106. }

    107. 

  107. 

    108. 

  108. hr.#footerHR

    109. 

  109. {

    110. 

  110. border-bottom-color: #EEEEFF;

    111. 

  111. border-bottom-style: solid;

    112. 

  112. border-bottom-width: 1;

    113. 

  113. border-top-color: C8CDDE;

    114. 

  114. border-top-style: solid;

    115. 

  115. border-top-width: 1;

    116. 

  116. height: 3;

    117. 

  117. color: #D2D2D2;

    118. 

  118. }

    119. 

  119. 

    120. 

  120. div.section

    121. 

  121. {

    122. 

  122. padding-top:    2;

    123. 

  123. padding-bottom: 2;

    124. 

  124. padding-right:  15;

    125. 

  125. width:  100%;

    126. 

  126. }

    127. 

  127. 

    128. 

  128. .heading

    129. 

  129. {

    130. 

  130. color:          #000000;

    131. 

  131. font-weight:    bold;

    132. 

  132. margin-top:     18;

    133. 

  133. margin-bottom:  8;

    134. 

  134. }

    135. 

  135. 

    136. 

  136. h1.heading

    137. 

  137. {

    138. 

  138. color: #000000;

    139. 

  139. font-size:  150%;

    140. 

  140. }

    141. 

  141. 

    142. 

  142. .subHeading

    143. 

  143. {

    144. 

  144. color:          #000000;

    145. 

  145. font-weight:    bold;

    146. 

  146. font-size:      150%;

    147. 

  147. margin-bottom:  4;

    148. 

  148. }

    149. 

  149. 

    150. 

  150. h2.subHeading

    151. 

  151. {

    152. 

  152. color:          #000000;

    153. 

  153. font-weight:    bold;

    154. 

  154. font-size:      130%;

    155. 

  155. }

    156. 

  156. h3.subHeading

    157. 

  157. {

    158. 

  158. color:  #000000;

    159. 

  159. font-size: 125%;

    160. 

  160. font-weight: bold;

    161. 

  161. }

    162. 

  162. 

    163. 

  163. h4.subHeading

    164. 

  164. {

    165. 

  165. color: #000000;

    166. 

  166. font-size: 110%;

    167. 

  167. font-weight: bold;

    168. 

  168. }

    169. 

  169. 

    170. 

  170. h4.procedureHeading

    171. 

  171. {

    172. 

  172. color: #000080;

    173. 

  173. font-size: 110%;

    174. 

  174. font-weight: bold;

    175. 

  175. }

    176. 

  176. 

    177. 

  177. h5.subHeading

    178. 

  178. {

    179. 

  179. color: #000000;

    180. 

  180. font-size: 100%;

    181. 

  181. font-weight: bold;

    182. 

  182. }

    183. 

  183. 

    184. 

  184. img

    185. 

  185. {

    186. 

  186. padding-bottom: 10;

    187. 

  187. }

    188. 

  188. 

    189. 

  189. img.toggle

    190. 

  190. {

    191. 

  191. border: 0;

    192. 

  192. margin-right: 5;

    193. 

  193. padding-bottom: 10;

    194. 

  194. }

    195. 

  195. 

    196. 

  196. img.copyCodeImage

    197. 

  197. {

    198. 

  198. border: 0;

    199. 

  199. margin: 1;

    200. 

  200. margin-right: 3;

    201. 

  201. padding-bottom: 10;

    202. 

  202. }

    203. 

  203. 

    204. 

  204. img.downloadCodeImage

    205. 

  205. {

    206. 

  206. border: 0;

    207. 

  207. margin-right: 3;

    208. 

  208. padding-bottom: 10;

    209. 

  209. }

    210. 

  210. 

    211. 

  211. img.viewCodeImage

    212. 

  212. {

    213. 

  213. border: 0;

    214. 

  214. margin-right: 3;

    215. 

  215. padding-bottom: 10;

    216. 

  216. }

    217. 

  217. 

    218. 

  218. img.note

    219. 

  219. {

    220. 

  220. border: 0;

    221. 

  221. margin-right: 3;

    222. 

  222. padding-bottom: 10;

    223. 

  223. }

    224. 

  224. 

    225. 

  225. img.#membersOptionsFilterImage

    226. 

  226. {

    227. 

  227. border: 0;

    228. 

  228. margin-left: 10;

    229. 

  229. vertical-align: middle;

    230. 

  230. padding-bottom: 10;

    231. 

  231. }

    232. 

  232. 

    233. 

  233. img.#toggleAllImage

    234. 

  234. {

    235. 

  235. margin-left: 4;

    236. 

  236. vertical-align: middle;

    237. 

  237. padding-bottom: 10;

    238. 

  238. }

    239. 

  239. 

    240. 

  240. div.#mainSection table

    241. 

  241. {

    242. 

  242. border: 0;

    243. 

  243. font-size: 100%;

    244. 

  244. width:  100%;

    245. 

  245. margin-top: 5px;

    246. 

  246. margin-bottom: 15px;

    247. 

  247. }

    248. 

  248. 

    249. 

  249. div.#mainSection table tr

    250. 

  250. {

    251. 

  251. vertical-align: top;

    252. 

  252. }

    253. 

  253. 

    254. 

  254. div.#mainSection table th

    255. 

  255. {

    256. 

  256. text-align: left;

    257. 

  257. background: #D8D8D8;

    258. 

  258. border-bottom-color: #D8D8D8;

    259. 

  259. border-bottom-style: solid;

    260. 

  260. border-bottom-width: 1;

    261. 

  261. color: #000000;

    262. 

  262. padding-left: 5;

    263. 

  263. padding-right: 5;

    264. 

  264. }

    265. 

  265. 

    266. 

  266. div.#mainSection table td

    267. 

  267. {

    268. 

  268. background: #F2F2F2;

    269. 

  269. border-top-color: #D8D8D8;

    270. 

  270. border-top-style: solid;

    271. 

  271. border-top-width: 1;

    272. 

  272. padding-left: 5;

    273. 

  273. padding-right: 5;

    274. 

  274. }

    275. 

  275. 

    276. 

  276. div.#mainSection table td.imageCell

    277. 

  277. {

    278. 

  278. white-space: nowrap;

    279. 

  279. }

    280. 

  280. 

    281. 

  281. div.code

    282. 

  282. {

    283. 

  283. width: 98%;

    284. 

  284. }

    285. 

  285. 

    286. 

  286. div.code table

    287. 

  287. {

    288. 

  288. border: 0;

    289. 

  289. font-size: 95%;

    290. 

  290. margin-bottom: 5;

    291. 

  291. width: 100%

    292. 

  292. }

    293. 

  293. 

    294. 

  294. div.code table th

    295. 

  295. {

    296. 

  296. text-align: left;

    297. 

  297. background: #D8D8D8;

    298. 

  298. border-bottom-color: #D8D8D8;

    299. 

  299. border-bottom-style: solid;

    300. 

  300. border-bottom-width: 1;

    301. 

  301. color: #000000;

    302. 

  302. font-weight: bold;

    303. 

  303. padding-left: 5;

    304. 

  304. padding-right: 5;

    305. 

  305. }

    306. 

  306. 

    307. 

  307. div.code table td

    308. 

  308. {

    309. 

  309. background: #CCCCCC;

    310. 

  310. border-top-color: #D8D8D8;

    311. 

  311. border-top-style: solid;

    312. 

  312. border-top-width: 1;

    313. 

  313. padding-left: 5;

    314. 

  314. padding-right: 5;

    315. 

  315. padding-top: 5;

    316. 

  316. }

    317. 

  317. 

    318. 

  318. div.alert

    319. 

  319. {

    320. 

  320. margin-left: 10;

    321. 

  321. width: 98%;

    322. 

  322. }

    323. 

  323. 

    324. 

  324. div.alert table

    325. 

  325. {

    326. 

  326. border: 1;

    327. 

  327. font-size: 100%;

    328. 

  328. width:  100%;

    329. 

  329. border: solid 1 #DEDFEF;

    330. 

  330. }

    331. 

  331. 

    332. 

  332. div.alert table th

    333. 

  333. {

    334. 

  334. text-align: left;

    335. 

  335. background: #D8D8D8;

    336. 

  336. border-bottom-width: 0;

    337. 

  337. color: #000000;

    338. 

  338. padding-left: 5;

    339. 

  339. padding-right: 5;

    340. 

  340. border: solid 1 #DEDFEF;

    341. 

  341. }

    342. 

  342. 

    343. 

  343. div.alert table td

    344. 

  344. {

    345. 

  345. background: #FFFFFF;

    346. 

  346. border-top-color: #D8D8D8;

    347. 

  347. border-top-style: solid;

    348. 

  348. border-top-width: 1;

    349. 

  349. padding-left: 5;

    350. 

  350. padding-right: 5;

    351. 

  351. border: solid 1 #DEDFEF;

    352. 

  352. }

    353. 

  353. 

    354. 

  354. span.copyCode

    355. 

  355. {

    356. 

  356. color: #0000ff;

    357. 

  357. font-size: 90%;

    358. 

  358. font-weight: normal;

    359. 

  359. cursor: hand;

    360. 

  360. float: right;

    361. 

  361. display: inline;

    362. 

  362. text-align: right;

    363. 

  363. }

    364. 

  364. 

    365. 

  365. .downloadCode

    366. 

  366. {

    367. 

  367. color: #0000ff;

    368. 

  368. font-size: 90%;

    369. 

  369. font-weight: normal;

    370. 

  370. cursor: hand;

    371. 

  371. }

    372. 

  372. 

    373. 

  373. .viewCode

    374. 

  374. {

    375. 

  375. color: #0000ff;

    376. 

  376. font-size: 90%;

    377. 

  377. font-weight: normal;

    378. 

  378. cursor: hand;

    379. 

  379. }

    380. 

  380. 

    381. 

  381. div.code pre

    382. 

  382. {

    383. 

  383. font-family:    Monospace, Courier New, Courier;

    384. 

  384. font-size: 105%;

    385. 

  385. color:  #000000;

    386. 

  386. }

    387. 

  387. 

    388. 

  388. code

    389. 

  389. {

    390. 

  390. font-family:    Monospace, Courier New, Courier;

    391. 

  391. font-size: 105%;

    392. 

  392. color:  #000000;

    393. 

  393. }

    394. 

  394. 

    395. 

  395. dl

    396. 

  396. {

    397. 

  397. margin-top: 0;

    398. 

  398. padding-left:   1;

    399. 

  399. }

    400. 

  400. 

    401. 

  401. dd

    402. 

  402. {

    403. 

  403. margin-bottom:  0;

    404. 

  404. margin-left:    0;

    405. 

  405. padding-left:   20;

    406. 

  406. }

    407. 

  407. 

    408. 

  408. dd p

    409. 

  409. {

    410. 

  410. margin-top: 5;

    411. 

  411. }

    412. 

  412. 

    413. 

  413. ul

    414. 

  414. {

    415. 

  415. margin-left: 17;

    416. 

  416. list-style-type: disc;

    417. 

  417. }

    418. 

  418. 

    419. 

  419. ul ul

    420. 

  420. {

    421. 

  421. margin-bottom: 4;

    422. 

  422. margin-left: 17;

    423. 

  423. margin-top: 3;

    424. 

  424. list-style-type: disc;

    425. 

  425. }

    426. 

  426. 

    427. 

  427. ol

    428. 

  428. {

    429. 

  429. margin-left: 24;

    430. 

  430. list-style-type: decimal;

    431. 

  431. }

    432. 

  432. 

    433. 

  433. ol ol

    434. 

  434. {

    435. 

  435. margin-left: 24;

    436. 

  436. margin-top: 3;

    437. 

  437. list-style-type: lower-alpha;

    438. 

  438. }

    439. 

  439. 

    440. 

  440. li

    441. 

  441. {

    442. 

  442. margin-top: 0;

    443. 

  443. margin-bottom: 0;

    444. 

  444. padding-bottom: 0;

    445. 

  445. padding-top: 0;

    446. 

  446. margin-left: 5;

    447. 

  447. }

    448. 

  448. 

    449. 

  449. p

    450. 

  450. {

    451. 

  451. margin-bottom: 15;

    452. 

  452. }

    453. 

  453. 

    454. 

  454. .tip

    455. 

  455. {

    456. 

  456. color:  #0000FF;

    457. 

  457. font-style: italic;

    458. 

  458. cursor:hand;

    459. 

  459. text-decoration:underline;

    460. 

  460. }

    461. 

  461. 

    462. 

  462. .math

    463. 

  463. {

    464. 

  464. font-family: Times New Roman;

    465. 

  465. font-size: 125%

    466. 

  466. }

    467. 

  467. .sourceCodeList

    468. 

  468. {

    469. 

  469. font-family: Verdana;

    470. 

  470. font-size: 90%;

    471. 

  471. }

    472. 

  472. 

    473. 

  473. pre.viewCode

    474. 

  474. {

    475. 

  475. width: 100%;

    476. 

  476. overflow: auto;

    477. 

  477. }

    478. 

  478. 

    479. 

  479. li:hover table, li.over table

    480. 

  480. {

    481. 

  481. background-color: #C0C0C0;

    482. 

  482. }

    483. 

  483. 

    484. 

  484. li:hover ul, li.over ul

    485. 

  485. {

    486. 

  486. background-color: #d2d2d2;

    487. 

  487. border: 1px solid #000;

    488. 

  488. display: block;

    489. 

  489. }

    490. 

  490.             </style>

    491. 

  491.   </head>

    492. 

  492.   <body>

    493. 

  493.     <!--Topic built:10/29/2007 02:41:57-->

    494. 

  494. 

    495. 

  495.     

    496. 

  496.     

    497. 

  497.     

    498. 

  498.     

    499. 

  499.     

    500. 

  500.     

    501. 

  501.     

    502. 

  502.     

    503. 

  503.     

    504. 

  504.     <div id="header">

    505. 

  505.       <table width="100%" id="topTable"><tr>

    506. 

  506.           <td align="left">

    507. 

  507.             <span id="nsrTitle">Readme_HelloWorld_CLR</span>

    508. 

  508.           </td>

    509. 

  509.           <td align="right">

    510. 

  510.             <span id="headfb" class="feedbackhead">

    511. 

  511.             </span>

    512. 

  512.           </td>

    513. 

  513.         </tr></table>

    514. 

  514.       

    515. 

  515.       

    516. 

  516.       

    517. 

  517.     </div>

    518. 

  518.     <div id="mainSection">

    519. 

  519.       <div id="mainBody"><p> 10/29/2007 2:41:57 AM</p>

    520. 

  520.         

    521. 

  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. 

  522.         <span id="changeHistory">

    523. 

  523.         </span>

    524. 

  524.     <p>This sample shows a simple, stateless application that uses the ServiceBrokerInterface sample.</p>

    525. 

  525.     <p>

    526. 

  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. 

  527.     </p>

    528. 

  528.   <h4 class="procedureHeading">Building and Installing the sample</h4><div id="procedureSectionEJBHA" class="section"><ol><li>

    529. 

  529.         <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">

    530. 

  530.           <p xmlns="">In Visual Studio 2005, open <code>HelloWorldCS.sln</code> or <code>HelloWorldVB.sln</code>.</p>

    531. 

  531.         </content>

    532. 

  532.       </li><li>

    533. 

  533.         <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">

    534. 

  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. 

  535.         </content>

    536. 

  536.       </li><li>

    537. 

  537.         <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">

    538. 

  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. 

  539.         </content>

    540. 

  540.       </li></ol></div><h4 class="procedureHeading">Running the sample</h4><div id="procedureSectionEHBHA" class="section"><ol><li>

    541. 

  541.         <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">

    542. 

  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. 

  543.         </content>

    544. 

  544.       </li></ol></div><h1 class="heading">Requirements</h1><div id="requirementsSection" class="section">

    545. 

  545.     <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">

    546. 

  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. 

  547.     </content>

    548. 

  548.   </div><h1 class="heading">Demonstrates</h1><div id="demonstratesSection" class="section">

    549. 

  549.     <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">

    550. 

  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. 

  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. 

  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. 

  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. 

  554.     </content>

    555. 

  555.   </div><!--[if gte IE 5]>

    556. 

  556. 			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>

    557. 

  557. 		<![endif]--></div>

    558. 

  558.       <div id="footer">

    559. 

  559. 			

    560. 

  560. 			© 2007 Microsoft Corporation. All rights reserved.

    561. 

  561. 		</div>

    562. 

  562.     </div>

    563. 

  563.   </body>

    564. 

  564. </html>
    565.