Written by:
Monday, June 13, 2011 

I often use EntitySpaces in projects and find that it works very well for multiple database connections. 

The guidance for using multiple connections is:

Register a connection as the ‘Default’

'Initialise EntitySpaces

        
            'Initialise Entity Spaces
            esProviderFactory.Factory = New EntitySpaces.Loader.esDataProviderFactory()

            Dim conn As New esConnectionElement
            'Manually register a connection 
            conn.ConnectionString = “…insert connection string …”
            conn.Name = "PrimaryDatabase"
            conn.Provider = "EntitySpaces.SqlClientProvider"
            conn.ProviderClass = "DataProvider"
            conn.SqlAccessType = esSqlAccessType.DynamicSQL
            conn.ProviderMetadataKey = "esDefault"
            conn.DatabaseVersion = "2005"

            esConfigSettings.ConnectionInfo.Connections.Add(conn)
            esConfigSettings.ConnectionInfo.Default = "PrimaryDatabase"

You can then add as many other connections, registering each with a unique name (only set one connection as the default).

To use a named connection, use the following syntax:

esUtility

esUtility u = new esUtility();
u.ConnectionName = "OptiQBackupDataBase";

Business Objects

// Single Entity
Employees emp = new Employees();
emp.es.Connection.Name = "OptiQBackupDataBase";

// Collection 
EmployeesCollection coll = new EmployeesCollection();
coll.es.Connection.Name = "OptiQBackupDataBase";

// Dynamic Query
EmployeesQuery query = new EmployeesQuery();
query.es2.Connection.Name = "OptiQBackupDataBase";

Trackback Print

Tags: EntitySpaces , Database

Categories: Code

Location: Blogs David Archer

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code Enter the code shown above in the box below
Add Comment   Cancel