VistaDB 5
Database Connections in a CLR Procedure

Inside the database?

Connecting to the database when you are already running internal to it can be confusing. You are already loaded into to the engine, and are operating on values directly inside the engine. But how do you send data back to the client who called you?

ADO.Net Interface

From the ADO.Net interface (using SQL) you would use the Context Connection to tell the engine you want the internal connection (this will fail if called externally).

Using Example to ensure Dispose
Copy Code
using (VistaDBConnection conn = new VistaDBConnection("Context Connection=true"))
{
    //your code here
}

This tells the VistaDBConnection to use the internal Context Connection rather than allocating a new connection to the database on disk. This is the exact same syntax as SQL Server 2005 and higher.

See Also