• Info
• Initial State
• View Source
• Run

Hosting

HO-S-5 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 event trigger SMS messages that are relayed via a .NET DOM frameworks based C# SOAP Client. It also demonstrates Virtuoso Server Pages session management.

Overview

HO-S-5 is a variation of HO-S-3 that makes use of VSPX session management

Prerequisites

The following prerequisites ensure the usability of these tutorial demos on Windows or Linux (and in other future Mono implementations):

• Linux
  • Mono Runtime and Frameworks (ideally the version bundled with Virtuoso)
  • Mono SDK (if you seek to write your own Objects for integration with Virtuoso)
  • Virtuoso Universal Server for Linux with Mono Hosting
• 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_dom.cs is an HttpWebRequest SOAP client using DOM to process SOAP result.
• The redcoalsms_dom.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
• This service is compatible with Mono (http://go-mono.com)

SID: bae734598f360b14f2f8e96f2239194d

UID: demo

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

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