Using connections from libraries

Hi,

Is it possible to use existing database connections from libraries in projects too?

At time i can only see the class definitions from business objects (defined in a library) in the c# editor - not the connections.

The advantage of only one connection definition is clear. I only have to change one connection paramater when i'm moving from test into the production area. Now i have to redefine this connection (each one with a different name) in every project i want to use it with SelectSql Statement in c#.

Thilo

Find more posts tagged with

BPM

Comments

Jerome_Pearce

We have done this, and it works perfectly well. Can you post an example of it not working?

Thilo_Menges

I will do the folowing form load statement:

this.Local.root_path = SelectSql(new MyLibConnection(), "SELECT TOP 1 path FROM CI WHERE alias = 'CI'", null).Text;

I defined the connection in a library, that is referenced by the project.

But i can't find the class definition in c# editor from the project form. Only if i define the connection in the project self, i can find that class in the c# editor intellisense. However, if i try to use the connection class from library, the designer shows error messages with worng type or namespace definitions.

Error 07.10.20** **:57:38 Der Typ- oder Namespacename "MyLibConnection" konnte nicht gefunden werden. (Fehlt eine Using-Direktive oder ein Assemblyverweis?)

Thilo

---
Note: Some information in this post has been hidden to protect privacy.

Jerome_Pearce

You need to use Metastorm.Runtime.Models.. or something like that.

Thilo_Menges

Thank you Jerome,

that was what i'm looking for

"Metastorm.Runtime.Models.SHD_LIB.MyConnection"

Thilo