Set Up the SQLCLRTutorialSPCall Solution - Single-project Literal

Copy the SQLCLRTutorialSPCall solution

1. Using Windows File Explorer or at a command prompt, create a subdirectory named SingleProjLiteral under your c:\tutorials\SQLCLR project parent directory.
2. Copy all files and subdirectories in the %PUBLIC%\Documents\Micro Focus\Enterprise Developer\Samples\Mainframe\SQL\OpenESQL\JCLCallingSP\SingleProjLiteral directory, to the c:\tutorials\SQLCLR\SingleProjLiteral directory.

Open the SQLCLRTutorialSPCall Solution

1. From the Visual Studio main menu, click File > Open > Project/Solution.
2. Browse to the c:\tutorials\SQLCLR\SingleProjLiteral directory.
3. Double-click SQLCLRTutorialSPCall.sln.

Set Project Properties

1. In the Solution Explorer, right-click the SPCall project; then select Properties from the context menu.
2. On the Debug tab (located on the left sidebar), using the drop-down list, set Launch to JCL.
3. Click Save .

Build the Solution

• In the Solution Explorer, right-click the solution; then select Build Solution from the context menu.

Publish SQL CLR Stored Procedures

1. In the Solution Explorer, right-click the SQLCLRTutorial.Publish project; then select Properties from the context menu.
2. On the Project Settings tab (located on the left sidebar), use the Target platform drop-down list to select the version of SQL Server used on your deployment machine. In this case, this is the version of SQL Server installed on your local machine.
3. Click Save .
4. In the Solution Explorer, right-click the SQLCLRTutorial.Publish project; then select Publish from the context menu.
5. On the Publish Database dialog box, click Edit.
6. In the Server name field, type . (dot) to represent your local server.
7. In the Select or enter database name field, select SQLCLR_Test from the drop-down list; then click OK.
8. On the Publish Database dialog box, click Publish.

   When the publishing process is complete, the Data Tools Operations window shows a status of "Publish Completed Successfully."