• Info
• Initial State
• View Source
• Run

3rd Party Runtime Hosting

HO-S-4 Hosting CLR types using VSPX session management

Demonstrating the use of C# to create Virtuoso hosted Stored Procedures and Triggers. In this demo a database events trigger SMS messages that are relayed via a C# based SOAP Client. It also demonstrates Virtuoso Server Pages session management.

Overview

This is a variation of HO-S-3 with the SOAP client implemented ASP.NET and also demonstrates Virtuoso Server Pages for XML (VSPX) session management.

Prerequisites

This demo currently works only on a Virtuoso server running under Microsoft Windows with following components installed:

• Windows
  • .NET Runtime and Frameworks
  • .Net Runtime and Framework SDK (if you seek to write your own Objects for integration with Virtuoso)
  • Virtuoso Universal Server for Windows with .NET CLR Hosting.

Tutorial Example

• The setup_sms.vspx sets up the SMS sending unit.
• The handler.vspx does inserts/deletes/updates to demonstrate the SMS sending from triggers.
• The redcoalsms*.cs is an MS Visual Studio.NET generated SOAP client.
• The redcoalsms.dll should be installed as a private assembly (not as CodeBase) because of permissions.
• For details of the Redcoal SOAP service see it's description in http://www.xmethods.com

SID: 8e2d276a2da5833d12c73970bc0981ab

UID: demo

In order to run this example you need Virtuoso Universal Server for Windows with .NET CLR Hosting.

View the source	Action
1. redcoalsms.sql	Set the initial state
2. handler.vspx	Run
3. redcoalsms.cs
4. redcoalsmsref.cs
5. setup_sms.vspx	Run