Home Products VistaDB 3.3 CLR Proc Tutorial

CLR Proc Tutorial

• How to create a CLR Proc
• DDA examples for usage of the CLR Proc
• SQL examples for usage of the CLR Proc (coming soon)

This demo was built using VS 2005.

Download the demo source code: HOWTO: Clr Proc Example

How to create a CLR Proc

Watch the video portion of the CLR Proc overview here: HOWTO CLR Function Overview

Key points from the presentation:

• Reference VistaDB like a normal application
• Classes must be public for the database to load them
• Functions must be public and static
• All types must be specified as VistaDBTypes
• The DLL must be loaded into the Database before it can be used (see below)

DDA Function Examples

Watch the complete DDA Examples demo here: DDA Clr Proc Functions

Key points from the presentation:

• How to attach a dll assembly into a database
• How to register a CLR Proc with the database
• How to call a CLR Proc from DDA
• How to detach the DLL from the database and verify it has been removed

SQL Function Examples

• This portion is not yet complete, please check back soon.