Tutorials
- Truly embedded ADO.NET 2 SQL database for Dot Net 2/3.x, Compact Framework and Mono
- Less than 1 MB single assembly deployment
- Cross-platform Windows, Linux and Mac OS X support through Mono
- Easy migration from SQL Server TSQL data types and syntax
- Royalty free distribution - Licensed per developer
CLR Proc HOWTO
- 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.