get MetastormDefault connection to use it in ADO.NET

Hi Milosz,

For database connection objects other than MetastormDefault(), you can get the ConnectionString property of the object to create your Ado.Net connection. MetastormDefault() does not expose this property, so best practice would be to maintain an external store for these values.

If you absolutely must get the same connection string that the engine uses as MetastormDefault(), then you can scrape the registry (although this is unsupported). The basic idea is as follows:

(This may require you to copy the Microsoft.Win32 DLL to the custom DLL folders)
 ..\[InstallDirectory]\Metastorm\BPM\Deployment\CustomLib\              
 ..\[InstallDirectory]\Metastorm\BPM\Designer\CustomLib\       
 ..\[InstallDirectory]\Metastorm\BPM\Engine\dotnetbin

using Microsoft.Win32;

public string GetConnString()
        {
            return RegValue(RegistryHive.LocalMachine, "SOFTWARE\\Wow6432Node\\Metastorm\\e-work\\Engine\\Database Connectors\\SQL Server DBC", "DotNetConnection");
        }

public string RegValue(RegistryHive Hive, string Key, string ValueName)
        {
            RegistryKey objParent = null;
            RegistryKey objSubkey = null;
            string sAns = null;
            switch (Hive)
            {
                case RegistryHive.ClassesRoot:
                    objParent = Registry.ClassesRoot;
                    break;
                case RegistryHive.CurrentConfig:
                    objParent = Registry.CurrentConfig;
                    break;
                case RegistryHive.CurrentUser:
                    objParent = Registry.CurrentUser;
                    break;
                case RegistryHive.DynData:
                    objParent = Registry.DynData;
                    break;
                case RegistryHive.LocalMachine:
                    objParent = Registry.LocalMachine;
                    break;
                case RegistryHive.PerformanceData:
                    objParent = Registry.PerformanceData;
                    break;
                case RegistryHive.Users:
                    objParent = Registry.Users;
                    break;
            }
            try
            {
                objSubkey = objParent.OpenSubKey(Key);
                //if can't be found, object is not initialized
                if ((objSubkey != null))
                {
                    sAns = (string)objSubkey.GetValue(ValueName);
                }
            }
            catch (Exception ex)
            {
                return ex.ToString();
            }
            return sAns;
        }